Thanks. a factor of 20 or even 30 from my numbers still gives a much larger number than the default one and i was wondering is there any disadvantage in having a big number/ cache?BTW, where is the TTL controlled ?
On Jan 6, 2008 7:23 AM, Yonik Seeley <[EMAIL PROTECTED]> wrote: > On Jan 6, 2008 12:59 AM, s d <[EMAIL PROTECTED]> wrote: > > What is the best approach to tune queryResultCache ?For example the > default > > size is: size="512" but since a document id is just an int (it is an > int, > > right?) ,i.e 4 bytes why not set size to 10,000,000 for example (it's > only > > ~38Mb). > > This cash size refers to the number of id lists are stored. > One query + sort that yields the top 20 results == 1 entry in the cache. > > -Yonik >
