My observation with 2.1.1 and load csv was not so bad, see my blog post:
http://jexp.de/blog/2014/06/using-load-csv-to-import-git-history-into-neo4j/
Can you make sure that your indexes are online? before the import query
starts?
Actually if you use MERGE consider using constraints instead.
CREATE CONSTRAINT ON (j:Joueur) assert j.IDJoueur is unique;
CREATE CONSTRAINT ON (t:TypePaiement) asset t.Type is unique;
schema await
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);
On Wed, Jun 4, 2014 at 9:03 AM, Mark Needham <m.h.need...@gmail.com> wrote:
> 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.
>
--
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.
