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.
