Robert Brown <r...@intelcompute.com> wrote: > Before I go out and throw more RAM into the system, in the above > example, what would you recommend?
That you try to determine what causes the slow response times. Replay logged queries (thousands of queries, not just a few) and see if the pauses are random or tied to specific queries. Turn on GC-logs to see if the pauses are caused by garbage collection. If the long response times are tied to specific queries, then try turning off queryResultCache and documentCache and replay a handful of the slow queries a few times. This ensures that the data needed are cached by the file system. If they continue being slow, then more RAM might not help you. - Toke Eskildsen
