Context: We have users. Users can be members of groups. Groups belong to tenants. Tenants = business context. Tenants form a hierarchy. [image] Query Now we have the following simplified query: PROFILE MATCH (u:User {Id: '<USER_ID>'})-[:MEMBER_OF]->(g:Group), (t:Tenant)-[:CHILD_OF*0..5]->(r…

I found out that described problem can be fixed by rewriting the query in the following way: MATCH (u:Usert {Id: '<USER_ID>'})-[:MEMBER_OF]->(g1:Group) WITH COLLECT(g1.Id) AS groups MATCH(t:Tenant)-[:CHILD_OF*0..5]->(root:Tenant)<-[:BELONGS]-(g2) WHERE g2.Id IN groups RETURN t.Id, g2.Id The m…

How to fix the un-optimal behavior of query engine

Neo4j Graph Platform Cypher

clem (Clem) January 7, 2021, 7:41pm 3

Also look here:

Topic		Replies	Views
How can I optimize my Cypher Queries? Cypher optimization , performance , cypher , knowledge-base	5	9254	February 9, 2021
How to optimize the query Cypher performance , cypher	0	445	February 6, 2020
How to Optimize a Query with Huge Where Clause Cypher performance , cypher	7	790	June 16, 2020
Cypher query extremely slow Cypher cypher	10	383	May 4, 2023
Help with optimizing query Cypher performance , browser , cypher , operations	3	428	September 21, 2021

Get Certified in June!

How to fix the un-optimal behavior of query engine

Related topics