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…

CURRENT SUBMISSIONS✦ @svignesh.8397Outbreak Analysis✦ @ramrajArt Provenance Agent✦ @serah.elrashidiGraphImmune Trust Agent✦ @anudhyandatta2021MovieGraph Agent✦ @sadashivbAthlete Nutrition Intelligence✦ @agung_sidharta_gungzSybil-Hunter Fraud Agent✦ @bhattacharya.ananya0OSS Sentinel✦ @abimael.carrasquilloJibarito Agent✦ @leongkwokhingTabletopGameRecommender✦ @strawberrychewyMental Health Assistant✦ @bruno.henrique.britoNeoSmith✦ @kitushenoyLifeGraph✦ @neerajchormale39GymBuddy✦ @neeraj42888Movie Graph Agent✦ @martynscnNaijaHealth✦ @rishabhprsd7Wortgraph Coach✦ @Rodrigo-TenorioChess Analytics Assistant✦ @priyagijainIPL Cricket Intelligence Agent✦ @joslatMarketMind✦ @ayushdeosinghHostLens AI✦ @hellopriyanshu4FraudGraph Sentinel✦ @winleexzCPF Customer Agent✦ @vinod.nageshwarGeospatial Supply Chain Agent✦ @jakub.kierznowskiiiDrugPath✦ @kumar20051020shivamVibeGraph AI✦ @wanga.15065M-Pesa (Kenya) Insight Agent✦ @epiphanyanEarnings Call Graph Analyst✦ @tarunnarang1992ReviewGraph AI✦ @violet.ols.devRecallScope Agent✦ @shrikantbhadaneAura-Health-Bot✦ @mabu.mateApple HealthGraph Agent✦ @ochiengokumu482VAT-TaxGraph AI✦ @mahanteshimathFinSight✦ @prashant7090Detect Cyber Attack✦ @jonas.koennerConspiracyGraph Agent✦ @deanfouldsJapan Seismic Risk Intelligence Graph✦ @jevlachovKorca Triage Agent✦ @shantanunitw01CineGraph AI✦ @dhiraj.patraRegulatoryRisk GraphAgent✦ @venkatasaiprasadpDepGraph Agent✦ Submissions are now closed

Learn graphs.
Score for your country.

Represent your country in the GraphAcademy Cup.
Complete courses, earn points, and win weekly prizes.

🏆 Join the Cup ⚽ Final Challenge

FINALS • July 16 - 19 ENDS IN

00 DAYS

00 HRS

00 MIN

00 SEC

Neo4j Online Community

LOAD CSV taking time

Neo4j Graph Platform Import / Export

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

Have a look here.

Topic		Replies	Views
Slow load_csv Cypher cypher	4	2074	July 29, 2019
Load CSV taking excessive amount of time Neo4j Graph Platform	2	595	February 22, 2023
CSV import issue Import / Export	26	851	June 21, 2023
Load-CSV very slow with millions of nodes Import / Export load-csv , import , neo4j-import , csv , neo4j	10	11870	April 7, 2022
Fastest way to load data in neo4j using python Cypher	5	10586	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