cancel
Showing results for 
Search instead for 
Did you mean: 

Adding Relationships query Hangs

amitshipra
Node Clone

Neo4j : 3.5.5
Driver : Python 1.7.2

Model is self explanatory. Book contains many instruments. Instrument has many dependencies

There are 1.3 M Relationships and 1.7 M Nodes. I ran the following query to add one more relationship with additional attribute. This is hanging.

        MATCH (book:Book)-[c:CONTAINS]->(instr:Instrument)-[d:DEPENDENCIES]->(dep:Dependency)
        CREATE (book)-[c1:CONTAINS {updated:"LATEST"}]->(instr)-[d1:DEPENDENCIES {updated:"LATEST"}]->(dep)

Possibly its not designed properly but wanted more inputs for this?

1 ACCEPTED SOLUTION

You might want to use transaction batching - check out apoc.periodic.iterate.

View solution in original post

1 REPLY 1

You might want to use transaction batching - check out apoc.periodic.iterate.