Can anyone recommend the most optimal method to remove 138M+ nodes, one label and one index?
So far MATCH (n:TheLabel) RETURN n LIMIT 1 is instant.
As soon as I try something like
MATCH (n:TheLabel) WITH n LIMIT 1 DETACH DELETE n it takes forever (yet to return).
I've also tried dropping the index. That is also taking forever.
Based on previous work with the dataset, I'm almost positive it's due to updating the index when deleting, that was the case when writing to the graph initially. That's why I'm trying to drop the index first.
Anyway if anyone has any tips, that do not involve APOC, I'm all ears.
graph version is 3.5.17 on a 3 server cluster.