Hi Michael,
I am facing a very similar problem that you might be able to suggest a solution to very quickly. Do you have a minute? Big fan of the clarity of your answers in the community
https://community.neo4j.com/t/how-to-aggregate-calculation-of-...
Do aggregations not make use of page cache?
I have a database with 4.6G of data, and 3.3G of indexes, the page cache is 10G, and is currently using 7.9G.
My queries are showing millions of db hits, even after all the db is loaded in memory?
tldr: Big neo4j dataset, trying to load into page cache. Only a part of the db being loaded. Queries with count very slow. Sysinfo and memrec showing different db data volumes. How to load the entire graph into memory, and reduce db hit counts?
I hav...
Thanks again for the answer @mike.r.black.
I assume you have an index on Genre.name to help speed up the seeking of the genre nodes?
Yes.
Is this what you're trying to achieve?
Not exactly. A few followup questions:
If the query to find track ...
Thanks a lot for the info and link @shan.
I'll go over the link now. Do you also happen to know how we can optimize a query like this to return as quickly as possible?
MATCH (t:Track)-[:HAS_GENRE]->(g:Genre)
WHERE g.name IN ['rock', 'metal']
RETURN ...
Basically, I have a graph with genres and tracks. About 1500 genres, and 7 Million tracks.
Page cache size is 10 Gb, heap is 10 Gb, and Database + Index size is 7.9G.
WITH ['rock', 'metal'] AS genres_list
MATCH (t:Track)-[:HAS_GENRE]->(g:Genre)
WHER...
