Yes if the query is "dynamic" it would be re-retrieved from the database server. And then cached. Unless the original query was not altered the cache would remain.
So keep the cache in place unless the query is more dynamic than static - otherwise the memory and resources could probably be better used by the system elsewhere. 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:02, 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. > > -- 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.
