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, 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 code base for another query with the same name. Or > rename the query, ie: qCountOfHorsesInRace#raceNo# (just an example) > > From the docs: "To use cached data, current query must use same SQL > statement, data source, query name, user name, password." > > Cheers. > > ps: maybe you could ride a horse down to the Melbourne user group ;) > > On 21/06/2011, at 6:01 PM, "Peter Tilbrook" <peter.tilbr...@gmail.com> wrote: > >> 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. > -- > 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.