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	9280	February 9, 2021
Speeding up query Cypher cypher	2	1793	March 15, 2019
Optimisation of a cypher query Cypher optimization	3	1084	January 29, 2019
Optimizing a Query Cypher	1	304	October 30, 2020
Performance query Cypher	0	756	October 29, 2018

Demystifying Neo4j UX Research

How to fix the un-optimal behavior of query engine

Related topics