See Section 3.3.14, “Importing CSV files with Cypher” on how to import data from CSV files.
Importing large amounts of data using
LOAD CSV with a single Cypher query may fail due to memory constraints.
This will manifest itself as an
For this situation only, Cypher provides the global
USING PERIODIC COMMIT query hint for updating queries using
You can optionally set the limit for the number of rows per commit like so:
USING PERIODIC COMMIT 500.
PERIODIC COMMIT will process the rows until the number of rows reaches a limit.
Then the current transaction will be committed and replaced with a newly opened transaction.
If no limit is set, a default value will be used.
See Section 220.127.116.11, “Importing large amounts of data” in Section 3.3.6, “LOAD CSV” for examples of
USING PERIODIC COMMIT with and without setting the number of rows per commit.