Re: JVM memory and query cache

2008-09-09 Thread Brad Wood
Quite possibly. What scope are you caching the query in? How many columns and records is the query? How many times is the query being cached? i.e. once for each user... If your operating system has enough RAM (remember to save some for Windows, SQL, etc) it is possible to increase the upper limit

Re: JVM memory and query cache

2008-09-09 Thread Fabio Serra
Brad Wood wrote: > When you say the Maximum is 640 MB, do you mean the "Maximum JVM Heap Size > (MB)" setting on the "Java and JVM" page of CF Administrator is set to 640? My Maximum JVM Heap Size (MB) in CF Administrator is set to 640 MB and -XX:MaxPermSize=192m The result of the cfml script (

Re: JVM memory and query cache

2008-09-09 Thread Brad Wood
When you say the Maximum is 640 MB, do you mean the "Maximum JVM Heap Size (MB)" setting on the "Java and JVM" page of CF Administrator is set to 640? Also, run this code: Max Memory Available to JVM: #Round(maxMemory)#MB Total Memory Allocated: #Round(totalMemory)#MB Free Allocated

Re: JVM memory and query cache

2008-09-09 Thread Fabio Serra
Tom Chiverton wrote: > On Tuesday 09 Sep 2008, Fabio Serra wrote: > >> The server has a lot of free memory, but I receive the JVM Memory Alert >> from ColdFusion. >> > > But how much of that is CF allocated to use ? > > Do you mean the JVM heap size? The maximum is 640 Mb and I have an a

Re: JVM memory and query cache

2008-09-09 Thread Tom Chiverton
On Tuesday 09 Sep 2008, Fabio Serra wrote: > The server has a lot of free memory, but I receive the JVM Memory Alert > from ColdFusion. But how much of that is CF allocated to use ? -- Tom Chiverton This email is sent for and on behalf of Ha

JVM memory and query cache

2008-09-09 Thread Fabio Serra
The maximum JVM heap size is used for the query cache too? I have in cache (using query cache) some large result set and the server sometimes respond very slowly. The server has a lot of free memory, but I receive the JVM Memory Alert from ColdFusion. I'm wondering if increasing the jvm heap size