Subject Index Caching
Author slalom91

Can someone please explain how indices are cached and how long they
remain in the cache of FB2 Superserver? I have a query which takes 20+
seconds initially. Subsequent identical queries executed immediately
after the first take 1-2 seconds. After several minutes the query is
executed again and it reverts back to 20 seconds. During this wait
period there are other queries being executed accessing different
pieces of information within the database. I am guessing that I just
need to tune the amount of pages to cache, but I'd like to make sure I
understand this clearly before making any adjustments to the config.