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. -- 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.
