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…

Check this out. You can force an early match that filters out the most irrelevant results, then follow up with matches that are broader. [image] How can I optimize my Cypher Queries? Cypher Here's an interesting trick to optimize a query. It involves manually breaking u…

Also look here: [image] How can I optimize my Cypher Queries? Cypher What should I do if my Cypher query is slower than expected, or uses more memory or CPU than I have? I'm running my queries with Neo4j Browser, copied from my application. What should I do? Are there an…

My first opinion - (good news) Just looking at the two steps of the profile - i see that there is a huge pagecache hits and 0 misses, which means the page cache is used to cache the data and avoiding accessing disk which will typically make the query run faster. If can you post the full query plan…

CURRENT SUBMISSIONS ✦ @mabu.mate Apple HealthGraph Agent ✦ @venkatasaiprasadp DepGraph Agent ✦ @dhiraj.patra RegulatoryRisk GraphAgent ✦ @shantanunitw01 CineGraph AI ✦ @jevlachov Korca Triage Agent ✦ @deanfoulds Japan Seismic Risk Intelligence Graph ✦ @jonas.koenner ConspiracyGraph Agent ✦ @mahanteshimath FinSight ✦ @prashant7090 Detect Cyber Attack ✦ @ochiengokumu482 VAT-TaxGraph AI ✦ @shrikantbhadane Aura-Health-Bot ✦ @violet.ols.dev RecallScope Agent ✦ @tarunnarang1992 ReviewGraph AI ✦ @epiphanyan Earnings Call Graph Analyst ✦ @wanga.15065 M-Pesa (Kenya) Insight Agent ✦ @kumar20051020shivam VibeGraph AI ✦ @jakub.kierznowskiii DrugPath ✦ @vinod.nageshwar Geospatial Supply Chain Agent ✦ @winleexz CPF Customer Agent ✦ @hellopriyanshu4 FraudGraph Sentinel ✦ Submit your Aura Agent Project to appear here

Neo4j Online Community

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	9499	February 9, 2021
Speeding up query Cypher cypher	2	1808	March 15, 2019
Questions about my query model Cypher querying , optimization , cypher , subquery	13	261	March 6, 2025
Optimizing a Query Cypher	1	331	October 30, 2020
Cypher query slow performance Cypher cypher	5	594	November 12, 2023

Take the Course Then Join The Aura Agent Hackathon

How to fix the un-optimal behavior of query engine

Related topics

Take the Course Then Join
The Aura Agent Hackathon