Can someone Reccomend a more efficient cypher query tht performs the following functionality

  Kiến thức lập trình

I am currently using the following query to delete a batch of nodes from my Neo4j graph database.`

String cypherCascadeDel= "UNWIND $conditions AS cond " +
            "MATCH (node:" + tableName + ") " +
            "WHERE ALL(key IN keys(cond) WHERE node[key] = cond[key])"+
            "DETACH DELETE node";

where condition is a List of Maps of type<String,Object>` .The list can contain upto 1 million entries and each map can contain upto 5 key value pairs.However this query is talking a lot of time.Around 20 min 15 min for 1,00,000 entries.Is there a better way to scale this?

  • neo4j
  • cypher
  • neo4jclient

LEAVE A COMMENT