Do you have an index on :Person(personid) ? What neo4j version?
Von meinem iPhone gesendet > Am 18.10.2014 um 07:14 schrieb Rodger <[email protected]>: > > Dear Experts, > > I have about 88K Person nodes. > > match (x) > return labels(x), count(*) > > +-----------------------+ > | labels(x) | count(*) | > +-----------------------+ > | ["Person"] | 87474 | > +-----------------------+ > 1 row > 531 ms > > > I'm using LOAD CSV to create about 360K relationships. > > USING PERIODIC COMMIT > LOAD CSV WITH HEADERS FROM "file:///home/notes/enron/mailgraph2.csv" AS > csvLine > MATCH ( from:Person { personid: toInt(csvLine.senderid ) }), ( to:Person { > personid: toInt(csvLine.recipientid )}) > CREATE ( from ) -[ :AGG_EMAILS > { > total_to: toInt ( csvLine.total_to ) > , total_cc: toInt ( csvLine.total_cc ) > , total_bcc: toInt ( csvLine.total_bcc ) > , total_emails: toInt ( csvLine.total_emails ) > } > ]-> ( to ) > ; > > > But I calculate that only 2.5 relationships are created per second after I > periodically count from another session: > > > match (from) -[r]-> (to) return count(*) ; > +----------+ > | count(*) | > +----------+ > | 8001 | > +----------+ > 1 row > 200 ms > > > > I tried correcting the autoindexing (see other thread), > deleting the relationships, and started the load again. > > But the load is still running at about the same speed. > > Is 2.5 inserts/creations of relationship per second typical? > > > Thanks a lot! > > > > -- > 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.
