Re: Query on Cache size.

2009-12-15 Thread Shalin Shekhar Mangar
On Mon, Dec 14, 2009 at 7:17 PM, kalidoss < kalidoss.muthuramalin...@sifycorp.com> wrote: > Hi, > > We have enabled the query result cache, its 512 entries, > > we have calculated the size used for cache : > page size about 1000bytes, (1000*512)/1024/1024 = .48MB > > The query result ca

Query on Cache size.

2009-12-14 Thread kalidoss
Hi, We have enabled the query result cache, its 512 entries, we have calculated the size used for cache : page size about 1000bytes, (1000*512)/1024/1024 = .48MB If we increase the cache count to 10 then the memory used for cache about. (1000*10)/1024/1024 = 96MB