Using apoc.periodic.iterate I need to create/update ~2M nodes.
In the middle of data laoding process I see some transactions are rotated once they reach 250M of file size. This rotation takes for 1 or 2 hrs, till then am not able to use my browser or cypher-shell and query doesn't move forward until rotation completes.
To avoid this I kept dbms.tx_log.rotation.size=1G will this help?
Or is there a better way to handle this ?