[thelist] CF: Clearing a cached query?

Raymond Camden jedimaster at macromedia.com
Tue Oct 15 13:23:00 CDT 2002


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

Plenty - if you need an easy way to clear the cache. Yes, you can run
the query again w/ 0 timeout, but it's also just as easy to kill the
variable using structDelete. Also - what if the menu is dynamic based on
session? Normal query caching may not work well in that case.

-rc





More information about the thelist mailing list