With the indexes set you must also use the labels in match, otherwise the
indexes won't be used. Sorry that I didn't do a comprehensive example,
something like this (the labels might be the wrong ones for the
relationshiptype BT.
Also either run against a server or make sure you've edited bin/neo4j-shell to
adapt it for the additional RAM.
> import-cypher -i bt.csv match (n:domain),(m:term) where n.id = {start} and
> m.id={end} create (n)-[:BT]->(m)
>
Am 10.03.2014 um 12:50 schrieb Tom Zeppenfeldt <[email protected]>:
> Hi Michael,
>
> explanation. doing import-cypher now. just wondering whether (on the 8 GB
> machine with specs at start of this thread, except for now working with Neo4j
> 2.0.1) performance for creating rels as below is "normal". Creating nodes is
> fast, but when i'm creating 1.2M rels I'm looking at 1200 mins ?
>
> neo4j-sh (?)$ import-cypher -i bt.csv match (n),(m) where n.id = {start} and
> m.id={end} create (n)-[:BT]->(m)
>
> Query: match (n),(m) where n.id = {start} and m.id={end} create
> (n)-[:BT]->(m) infile bt.csv delim ',' quoted false outfile (none) batch-size
> 1000
>
> commit after 1000 row(s) 0. 12%: nodes = 0 rels = 1000 properties = 0 time
> 55684 ms total 55684 ms
>
> commit after 2000 row(s) 1. 24%: nodes = 0 rels = 2000 properties = 0 time
> 53724 ms total 109408 ms
>
> commit after 3000 row(s) 2. 36%: nodes = 0 rels = 3000 properties = 0 time
> 56033 ms total 165441 ms
>
> commit after 4000 row(s) 3. 42%: nodes = 0 rels = 4000 properties = 0 time
> 54584 ms total 220025 ms
>
> commit after 5000 row(s) 4. 54%: nodes = 0 rels = 5000 properties = 0 time
> 55677 ms total 275702 ms
>
> commit after 6000 row(s) 5. 67%: nodes = 0 rels = 6000 properties = 0 time
> 53673 ms total 329375 ms
>
> commit after 7000 row(s) 6. 73%: nodes = 0 rels = 7000 properties = 0 time
> 54792 ms total 384167 ms
>
> commit after 8000 row(s) 7. 85%: nodes = 0 rels = 8000 properties = 0 time
> 56940 ms total 441107 ms
>
> commit after 9000 row(s) 8. 97%: nodes = 0 rels = 9000 properties = 0 time
> 54738 ms total 495845 ms
>
> finish after 9597 row(s) 9. 99%: nodes = 0 rels = 9597 properties = 0 time
> 34251 ms total 530096 ms
>
> Import statement execution created 0 rows of output.
>
>
> --
> 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.
