Can you verify that your indexes are online? before you start using LOAD CSV ?
On Fri, Jun 6, 2014 at 6:28 AM, Andres Taylor < [email protected]> wrote: > If you are able to, could you run these in the shell, and prepend them > with profile? The output should reveal the secret. > > Thanks, > > Andrés > > > On Thu, Jun 5, 2014 at 12:09 PM, Comte Frédéric <[email protected]> > wrote: > >> Thx for your responses. >> My index are online. >> In fact my problem is not exactly the one I described : >> >> This request is very long on 2.1.0-RC2 and 2.1.1 >> >> CREATE INDEX ON :Joueur(IDJoueur); >> CREATE INDEX ON :Tech(Tech); >> USING PERIODIC COMMIT >> LOAD CSV FROM "file:///tmp/X.csv" AS csvLine WITH csvLine[0] as >> csvidevt,csvLine[1] as csvtech,csvLine[2] as csvjoueur,csvLine[3] as >> csvunitejeton,csvLine[4] as csvsoldemouvement,csvLine[5] as >> csvmontantabond,csvLine[6] as csvbonusmouvement >> MERGE (joueur:Joueur { IDJoueur: csvjoueur}) >> MERGE (tech:Tech { Tech: csvtech}) >> MERGE (joueur)-[:CAVE{IdEvt: csvidevt,UniteJeton: >> csvunitejeton,SoldeMouvement:csvsoldemouvement,MontantAbond: >> csvmontantabond,BonusMouvement: csvbonusmouvement}]->(tech); >> >> And this one is fast ( 40 s ): >> CREATE INDEX ON :Joueur(IDJoueur); >> CREATE INDEX ON :Tech(Tech); >> USING PERIODIC COMMIT >> LOAD CSV FROM "file:///tmp/X.csv" AS csvLine >> >> MERGE (joueur:Joueur { IDJoueur: csvLine[2]}) >> MERGE (tech:Tech { Tech: csvLine[1]}) >> MERGE (joueur)-[:CAVE {IdEvt: csvLine[0],UniteJeton: csvLine[3] >> ,SoldeMouvement: csvLine[4],MontantAbond: csvLine[5],BonusMouvement: >> csvLine[6]}]->(tech); >> >> Do you have a clue? >> >> -- >> 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 [email protected]. >> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
