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 whatever database server you use (what are you using? I use 3 iterations of SQL Server) changes between CF and the database server - expecting a different and not the same result (same result use the cached result) a new query will be made and THAT will then be cached. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:08, Paul Kukiel <kuki...@gmail.com> wrote: > 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 cached or not. > Paul. > On Tue, Jun 21, 2011 at 5:02 PM, Andrew <am2...@gmail.com> wrote: >> >> 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" datasource="somedatasource" >> cachedwithin="#CreateTimeSpan(0,5,0,0)#"> >> .... >> </cfquery> >> >> Please take my word for it that the query does not change, but it DOES >> have a couple of nested selects (not sure that would be a factor?). >> >> I set up a test page, and it appears to remain cached for a couple of >> minutes and then disappear from the cache. >> >> The CF Administrator is set to cache 100 queries, and looking at the >> monitor it seems to flucuate between about 2 and 8 cached queries in >> total, so I am pretty sure we aren't hitting the limit. >> >> So my question is - how can I debug this? I believe the requirements >> specified in the doco are being meet, eg: >> >> "the current query must use the same SQL statement, data source, query >> name, user name, and password" >> >> However, one possible thing I can think of is, what if there was the >> same SQL statement being called with a different datasource. Would >> that cause this one to be lost? Or would they both be cached >> independently? Because this is a possibility, as we have a staging >> instance on the same coldfusion instance. >> >> Hopefully that all makes sense...it's a bit hard to explain... >> >> 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 >> http://groups.google.com/group/cfaussie?hl=en. >> > > > > -- > Paul Kukiel > > -- > 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.
