Adding Relationships query Hangs

[amitshipra]

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?

[stefan_armbrust · Accepted solution]

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