Skip to main content
K
karlkrist
Inspiring
May 6, 2010
Question

CF 9 Enterprise - Queries not caching?

  • May 6, 2010
  • 2 replies
  • 720 views

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

This topic has been closed for replies.

2 replies

A
Adam Cameron.
Inspiring
May 9, 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

D
Dan_Bracuk
Inspiring
May 7, 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices