[thelist] CF: Clearing a cached query?

[Morgan Kelsey]

> > Here's what I would suggest--create a routine to do the query
> > and push the
> > data to disk in a manner that can be quickly read by CF.
> > Writing out CF code
> > to be cfincluded later would be my suggestion.  The file
> > should be nothing
> > more than a bunch of cfsets, such as:
> >
> > <cfset nav = ArrayNew(1)>
> > <cfset nav[1] = StructNew()>
> > <cfset nav[1].title = "title1">
> > <cfset nav[1].href = "href1">
> > ...
> > etc
> > ...
> >
> > Then, cfinclude this file within application.cfm.  Any time that the
> > navigation changes, rerun the code that generates the file.
> > It'll be real
> > quick on the front end.
>
> By the same token, I'd suggest using the application scope as well,
> although it won't "stick" as long as using the file system.
>
> -ray
>
>

c'mon guys, what are we saving here?

if rudy's setting the cache to an hour, these aren't improvements at all.
he already has the nav sitting in memory as a query object, whats the point
of reproducing it as an array?
how long will it take for that query to run, 20ms?


nagrom