Hi Everyone, I am loading a csv file to create nodes in neo4j, when I tried with a csv of around 1,000 rows it took 1 second for the nodes to be created, when I increased my dataset to 3,000 rows it is taking 15 seconds. Can someone please suggest, how to reduce this time and why is this differenc…

Creating an index helped me to reduce the time in relationship creation

Hello @pragyasood28 :slight_smile: Did you create a UNIQUE CONSTRAINT on a node property? Regards, Cobra

Hi, No I haven't created a UNIQUE CONSTRAINT, but the property name which I am creating for my nodes will always be unique as that's how I create my input csv. So I know that multiple nodes will not be created. Just now I tried to create Unique Constraint on my Storage Node, after importing the cs…

Hi, My nodes are now getting created within milliseconds as I changed my cypher query from merge to create, but my relationship is taking around 60 seconds. Any suggestions on how to increase the speed of relationship creation from csv. Below is the code that I have used: load csv with headers f…

Just some context for this... When there is no index present, then, per row, Cypher will do a label scan for every single :Storage node, performing property access to see if the node exists. So if you have 10000 :Storage nodes in the database, and 3000 rows in the CSV, then it will be performing 3…

LOAD CSV taking time

Neo4j Graph Platform Import / Export

Cobra (Cobra) September 23, 2021, 3:02pm 4

Have a look here.

1 Like

Topic		Replies	Views
Slow load_csv Cypher cypher	4	2069	July 29, 2019
Load CSV taking excessive amount of time Neo4j Graph Platform	2	587	February 22, 2023
CSV import issue Import / Export	26	815	June 21, 2023
Load-CSV very slow with millions of nodes Import / Export load-csv , import , neo4j-import , csv , neo4j	10	11829	April 7, 2022
Fastest way to load data in neo4j using python Cypher	5	10451	May 5, 2021

Take the Course Then Join The Aura Agent Hackathon

LOAD CSV taking time

Related topics

Take the Course Then Join
The Aura Agent Hackathon