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 zero-timespan or restart the CF service/daemon
Cheers Kai > 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 QUERY > until it is notified that a cached query has changed – it does this > automatically. > > So. > > 1. CF request a QUERY from your database server. > 2. DB sends back result and CF caches it – for 5 or how many hours. > 3. Multiple request made to DB and CF gets same result so uses the cache > instead. All good. > 4. But one single requests alters the DB response. CF caches the new > result. This new result is now the CACHE result. > 5. All good no more changes for 5 hours. At 5:15 a new query to DB. > Cache has expired. DB responds. CF creates a new CACHE with that result. > > That in a nutshell is how is works. > > Only been using CF for 16 years next month so am I right? > > > 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 > 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 request. If the database server itself says "the > results are different now" than obviously the result given to CF is now > changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. > > Get it? -- 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 http://groups.google.com/group/cfaussie?hl=en.
