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.
