CODEWITHSUNDEEP
neo4jcypherlimit
x13
x13

Reputation: 327

Cypher query limit results and delete

I am trying to remove 20000 nodes which have datestamp property = 20130808 but when I replace "DELETE nx" with "RETURN COUNT(nx)" the result is 7880 and not 20000, at this moment I have 1000000 nodes in Neo4j 1.9.2. How can I make that correctly?

Cypher query:

START nx=node(*)
WITH nx
LIMIT 20000
WHERE HAS (nx.datestamp) AND nx.datestamp = 20130808 AND ID(nx) <> 0
DELETE nx

Upvotes: 3

Views: 3548

Answers (1)

Stefan Armbruster
Stefan Armbruster

Reputation: 39905

Thats because you first choose 20k arbitrary nodes and then apply the WHERE filter. You have to do it the other way round:

START nx=node(*)
WHERE HAS (nx.datestamp) AND nx.datestamp = 20130808 AND ID(nx) <> 0
WITH nx
LIMIT 20000
DELETE nx

Be aware that this kind of global operation with property access is expensive. A better approach would be to enable autoindexing for datestamp and then do:

START n=node:node_auto_index(datestamp=20130808)
WITH n
LIMIT 20000
DELETE n

Upvotes: 6

Related Questions