Just to clarify, the cached = false appears every couple of minutes, despite
the cachedwithin timespan asking for 5 hours...
On 21 June 2011 17:36, Andrew am2...@gmail.com wrote:
Doing a cfdump shows cached = true most of the time, but every now
and then it shows cached = false.
--
You
If the QUERY result changes (the result) the CACHE changes. This is the
point. If the query has NOT changed CF will use what is stored. Otherwise it
re-requests the data from the database server.
ColdFusion is NOT a database server. Your database returns a result to
ColdFusion based on what CF
I would have a look into that datasource idea with your staging environment
again. Maybe just build a simple testcase and see if calling the logic that
runs the query in staging triggers the re-execution of the query in production.
Also - you're 100% sure there that it doesn't get kicked out of
But it shouldn't go back to the database to check if it's changed, if it's
truly cached. What would be the point of caching, if it had to check
anyway?
On 21 June 2011 17:53, Peter Tilbrook peter.tilbr...@gmail.com wrote:
If the QUERY result changes (the result) the CACHE changes. This is the
But it shouldn't go back to the database to check if it's changed, if it's
truly cached. What would be the point of caching, if it had to check
anyway?
Yes - it should. Because you are caching results that do not change for a
long time. The CACHEDWITHIN is a measure of how long CF will store a
But it shouldn't go back to the database to check if it's changed, if it's
truly cached. What would be the point of caching, if it had to check
anyway?
It takes milliseconds for CF to check as opposed to many many seconds to
retrieve database records that you would normally cache and not
Nope, you're wrong re 4. There's no underlying magic that notifies CF that a
query has changed. If you cache a query for whatever timespan CF doesn't talk
to the server for that timespan at all unless you flush the query cache by for
instance setting cachedwithin for that query to a
Basterd ;) I think you are right - been a long time since I've needed to
cache a query. You are right I remember. Cache for 5 minutes - yup 5 minutes
- unless some sort of error?
An interesting point - caching the WRONG or OUT OF DATE stuff can be worse
than not caching at all.
Tired -
Do you really think that sort of language is needed or appropriate?
From: Peter Tilbrook [mailto:peter.tilbr...@gmail.com]
Sent: Tuesday, 21 June 2011 6:22 PM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] Re: cfquery cachedwithin
Basterd ;) I think you are right - been a long
Andrew, I realise I'm jumping in late, so apologies if this has already been
mentioned, or I'm completely wrong.
I think the query name needs to be more unique. If your server runs another
query with the same name but different SQL, the cache will be overwritten.
Maybe do a search thru you
Sorry Steve - tongue in cheek not meant to offend!
Sorry again!
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com.
To unsubscribe from this group, send email to
That's what I tried to say! Thx Mr Buzzy!
Definately use caching where appropriate. On DB heavy apps it can be
really handy.
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com.
To
Thanks guys. A few things for me to check tomorrow.
I'm not overly familiar with this part of the app, and I'll also look at
whether 5 hrs is an appropriate length of time to cache it for too.
Andrew.
Sent from my mobile
On 21/06/2011, at 6:24 PM, MrBuzzy mrbu...@gmail.com wrote:
Andrew,
:)
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
.)
/charlie
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On
Behalf Of Kym Kovan
Sent: Tuesday, June 21, 2011 8:53 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Re: cfquery cachedwithin
Andrew,
sorry more than a bit late
15 matches
Mail list logo