I must admit I'm quite baffled at this. I've gone through quite a bit of work adding some extra nodes to help make - what would be a really bad range query - profile quite nicely. But it runs incredibly slowly the first time, and subsequently quite fast. I presume this is due to disk access and load…

Extremely slow query when profile looks very good?

duane_nickull (Duane Nickull) October 3, 2019, 5:05am 9

Topic		Replies	Views
Memory settings for big databases Server performance	40	3327	August 1, 2019
An effort to better understand the underlying mechanism of query filters and profiling Graph Data Science / Graph Analytics performance , cypher	12	996	July 27, 2020
Query cache for speeding up queries Cypher performance , cypher	13	791	April 7, 2022
How to fetch millions of data faster? Cypher	30	8593	October 18, 2019
Query optimalisation Cypher	25	2496	February 25, 2019