HI Frederic, Could you try profiling that query on 2.1.1 - perhaps truncate the CSV file a bit first though!
In http://localhost:7474/webadmin PROFILE USING PERIODIC COMMIT 1500 LOAD CSV FROM "file:///tmp/file.csv" AS csvLine MERGE (joueur:Joueur { IDJoueur: csvLine[2]}) MERGE (type:TypePaiement {Type: csvLine[3]}) MERGE (type)-[:ALIMENTE{IdEvt: csvLine[0],Montant: csvLine[1]}]->(joueur); And paste the results. On 2 June 2014 13:02, Comte Frédéric <ezreal92...@gmail.com> wrote: > Hi all, > > I am quite new to neo4j and I try to import csv data in neo4j. > > I tried the following methods : > > - using load csv in neo4j in 2.1.0-M01 , 2.1.0-RC2 , 2.1.1. I use the > following request > > CREATE INDEX ON :Joueur(IDJoueur); > CREATE INDEX ON :TypePaiement(Type); > USING PERIODIC COMMIT 1500 > LOAD CSV FROM "file:///tmp/file.csv" AS csvLine > MERGE (joueur:Joueur { IDJoueur: csvLine[2]}) > MERGE (type:TypePaiement {Type: csvLine[3]}) > MERGE (type)-[:ALIMENTE{IdEvt: csvLine[0],Montant: csvLine[1]}]->(joueur); > > I find that the performance is very low since the 2.1.0-RC2 release. ( 60 > s for 200 k nodes and relationships in 2.1.0-M01 , 1 hour for the same data > and request for 2.1.0-RC2 and 2.1.1 ) > I don't understand this behaviour since it's on the same machine (64 go of > ram) with the same configuration. > Is someone use the new load csv in this new version without any problem on > quite big load? > > - using batch importer from michael hunger with a 2.0 version. The > performance are impressive and I wonder if I can merge data in stead of > create it? > > Cheers, > Frédéric > > > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
