Clearing all Cached Queries at Once?
It's a pretty simple matter to clear all the queries accessed in a request, say by setting a clearcache url var, and writing the code to set the cache span to a nil duration when url.clearcache exists. Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) Q2. Also, say I've got a dynamic query... cfquery ...select * from t where c = #v#/cfquery ... and I clear the query when v = 1, does this all-at-once clear the other cached versions (which were cached when v equaled 2 and v equaled 3)? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Clearing all Cached Queries at Once?
Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) cfobjectcache action=""> This clears the entire server's set of cached queries. Q2. Also, say I've got a dynamic query... cfquery ...select * from t where c = #v#/cfquery ... and I clear the query when v = 1, does this all-at-once clear the other cached versions (which were cached when v equaled 2 and v equaled 3)? No, cached queries are indexed by their sql and the other attributes to the tag. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Clearing all Cached Queries at Once?
Brilliant, thanks. Jamie On Tue, 6 Jan 2004 12:47:04 -0600, in cf-talk you wrote: Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) cfobjectcache action=""> This clears the entire server's set of cached queries. Q2. Also, say I've got a dynamic query... cfquery ...select * from t where c = #v#/cfquery ... and I clear the query when v = 1, does this all-at-once clear the other cached versions (which were cached when v equaled 2 and v equaled 3)? No, cached queries are indexed by their sql and the other attributes to the tag. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]