Dear all, the following is my RAM information in task manager when I'm query for about 1000 million nodes.
However, whenever I tried 1000 million, 5000 million, 10,000 million or event 50,000 million node, the usage of my RAM are all about 12% (62/515) with 88% free left. How can I increase the usage of my RAM as larger as possible so it would be more efficiency? Thanks.
You should execute the command neo4j-admin memrec (Neo4j 4.4) or neo4j-admin server memory-recommendation (Neo4j 5) to get an initial recommendation on how to configure memory parameters for Neo4j.
I had already set the initial_size, max_size and pagecache to the value what neo4j-admin server memory-recommendation showed and even try different value before, but the RAM still all about 12% (62/515) with 88% free left.
Based on the evidence, it seems like Task Manager just doesn't do a good job reporting memory use. If you're getting good performance, don't see evidence of swapping -> win