[thelist] CF: Clearing a cached query?
Raymond Camden
jedimaster at macromedia.com
Tue Oct 15 10:50:10 CDT 2002
> > Your tests are incorrect - and I should have been more clear.
> >
> > If you run 2 queries with different white space, where the
> first query
> > has a time out of X minutes and the second query has a timeout of 0
> > minutes, you WILL see that the second query is not cached,
> ie, the debug
> > out does NOT show it being cached, however if you rerun the
> first query
> > AND it's within X minutes, it will still show the cached
> data. To prove
> > this, you need to update your tests. Run the first query, run the
> > modified second query with a 0 length timeout, then return
> the first and
> > verify that it is marked cached.
> >
>
> ah, i see what you are saying.
> i must say that seems silly, though.
> if whitespace is insignificant in SQL, why does CF care?
I agree. It's a "issue" in my book. :>
I'll add an enhancement request for:
Make query caching ignore white space. At the LEAST we can make
it ignore leading/trading white space.
Make it simpler to remove query caches.
(Please note - when I say I'll add an enhancement request, it just means
I'll add it to our internal bug tracker. It doesn't mean it will get
implemented. I'm a very small cog at Macromedia, and in a few months I
won't even be that, so don't count on it being done. :)
=======================================================================
Raymond Camden, ColdFusion Jedi Master for Hire
Email : jedimaster at macromedia.com
WWW : www.camdenfamily.com/morpheus
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
More information about the thelist
mailing list