Hey everyone,
I have some issues importing a set of relationships from a CSV file.
I'm running Neo4j 2.1.7 under Mac OSX (10.9.5), 16GB RAM.
The file has the following schema:
user_id, shop_id
1,230
1,458
1,783
2,942
2,123
etc.
It contains about 2M records (relationships).
Here is the query I'm running using the browser UI (I was also trying to do
the same with a REST call):
> USING PERIODIC COMMIT
> LOAD CSV WITH HEADERS FROM "file://path/to/my/file.csv" AS relation
> MATCH (user:User {id: relation.user_id})
> MATCH (shop:Shop {id: relation.shop_id})
> MERGE (user)-[:LIKES]->(shop)
>
This query takes ages to run, about 800 seconds. I do have indexes on
:User(id) and :Shop(id). Created them with:
> CREATE INDEX ON :User(id)
CREATE INDEX ON :Shop(id)
Any ideas on how to increase the performance?
Thanks
--
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.
