Get rid of two way redundant relationships for very large database?

Hello, I have a problem, I created and pushed relationships between nodes and I realized, I have by mistake pushed redundant relations A-rel1->B and A<-rel2-B. I don't require relationship rel2. I found some solutions here https://stackoverflow.com/a/37242017/6439212 but the size of my graph is very big and rel1+rel2 approximately 100 million relations. It is taking forever to delete these relationships. Can anyone please tell me the faster solution to delete these redundant relationships?

I think this will do the trick: Large Delete Transaction Best Practices in Neo4j - Knowledge Base

In general, if you need speed, see if there is an APOC function that can do what you want.

1 Like