My query is taking 52 seconds to load (returning 1419 rows)
MATCH (sn:Snapshot)--(z:Requirement {type:'super'})--(m:Requirement {type:'sub'}) MATCH (m)-[r1]-(c:Code)-[rv1]-(sn) MATCH (m)-[r2]-(t:Test)-[rv2]-(sn) RETURN DISTINCT z AS super, COLLECT(DISTINCT m) AS sub, COLLECT(DISTINCT [c,r1,rv1]) AS code,COLLECT(DISTINCT [t,r2,rv2]) AS test
I have about 634228 relationships and 91176 nodes.
I have indexes on the nodes and auto indexes on the relationships. I have been trying many approaches but can't find the way to reduce the time.
Please let me know if you need more information about it, I'm a beginner with Neo4j.
Thank you.
:Requirement {type}
? Is that an initial or subsequent query? Please share your query plan (prefix your query with "PROFILE"). - Michael Hunger