Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
01-17-2023 12:53 AM
The following code
CALL apoc.periodic.iterate("MATCH(e:Process) MATCH (f:ParentProcess{pid:e.parentID}) RETURN e,f",
"CREATE(f)-[r:create_process_to]->(e)",
{batchSize:5000, parallel: true}) YIELD batch
Showed the error message : The allocation of an extra 2.0 MiB would use more than the limit 21.0 GiB. Currently using 21.0 GiB. dbms.memory.transaction.total.max threshold reached
After setting the related-configuration, although the error message do not show up but it spend sever hours and no any result was showed, even I changed Batchsize into (100,500,1000).
This may because there're 640 millions nodes, since in the cases of 300 millions node it turn the result wtih only 1 hours successfully.
Problem : How can I get over in this situation (at least show the result...) except create index for them which I were trying now.
Conf. setting :
Since recommended : (There're 512 GB Memory in my computer)
All the sessions of the conference are now available online