Hi guys,
Still struggling with this issue. Nothing in my production box's query
cache seems to last more than about 3 minutes, but on my dev server it seems
to work as expected (ie cache for the required amount of time).
I've looked for things like other queries with the same name, calls to
Hi,
A colleague has asked me to investigate some code that he claims used
to cache, but at some point recently doesn't anymore.
Sadly, I can't replicate the exact code / query here (I expect my boss
would have a fit if I did), but to paraphrase it, it's something
like:
cfquery name=qCount
Yes if the query is dynamic it would be re-retrieved from the
database server. And then cached. Unless the original query was not
altered the cache would remain.
So keep the cache in place unless the query is more dynamic than
static - otherwise the memory and resources could probably be better
The cache is based on the QUERY=myQuery. If that query is altered
(dynamic) from when the cache was created - basically a totally
different query - the cache would be recreated using the new SQL that
was requested.
Peter Tilbrook
Managing Director, ColdGen Internet Solutions
Professional Adobe
Do you use ColdFire? ( now works with FF 4 )
You can watch all queries on each page hit and it will tell you if its
cached or not.
You can also watch this with *Enable Request Debugging Output* turend on
although it will mess up your HTML in some cases.
That way you can prove if its being
Query caching is great for things that you KNOW won't change for ages,
eg OZ PostCode/Suburbs you can safely cache for 24hours but still a
pain in the butt to get source file from AusPost but as an example.
Not every query needs to or even should be cached.
Basic rule of thumb is if SQL or
(and
CFBuilder)
More at http://www.carehart.org/consulting
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On
Behalf Of Andrew
Sent: Tuesday, June 21, 2011 3:02 AM
To: cfaussie
Subject: [cfaussie] cfquery cachedwithin
Hi,
A colleague has