CF 9 Enterprise - Queries not caching?

Report · May 06, 2010

Hello all-

I posted earlier regarding a problem I am having with CF9 Enterprise being very slow when connecting to SQL Server 2008.

I turned on the Server Monitor on CF, then looked at the Cached Queries report (Statistic-Cached Queries).

I have monitoring on, I am profiling, and tracking memory - all are required according to the cached queries page. BUT- according to the report, I do not have any cached queries. My 'slowest queries' report (which I have dropped down to 1 second threshold) DOES show queries.

My question is- is it possible my server just isn't caching queries? I have changed the 'maximum number of cached queries' number a few times. Currently it is sitting at 100. The server isn't live yet, so this number is fine.

OR- does server monitor not work for showing cached queries?

Screen shot of my server monitor, to show the settings at the top, and lack of cached queries in the report.

Any help would be appreciated.

Thanks,

Karl

Report · May 07, 2010

To see if your server is caching queries, write a page that shows debugging information and contains a query with a chachedwithin attribute. Run the page and look at the debugging info for that query. Then refresh it and look at the same debugging info. If the query got cached, the debugging info will indicate such.

Report · May 09, 2010

Are you telling your queries to cache? IE: with cachedwithin or cachedafter in your <cfquery> tag?

CF doesn't cache 'em unless you tell it to, because it's not desirable behaviour in most situations.

--

Adam