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.
