method for doing that be to execute the same query and give it a new
cachedwithin value of #CreateTimeSpan(0,0,0,0)# to kill the cache from
the backend and then when the frontend query is called again, it will
reset the cache? I'm just curious how CF differentiates cached queries.
If the front end has one application name and the backend has another,
does it handle the cached queries separate even though they're the exact
same query?
John
-----Original Message-----
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:58 AM
To: CF-Talk
Subject: RE: Cached Queries
You can use <cfobjectcache action = "" to clear all cached queries
Qasim
-----Original Message-----
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:53 AM
To: CF-Talk
Subject: Cached Queries
I have an app with a front end (the main site that users see) and a
backend (an admin app for updating articles, calendar events, etc). On
the front end, I want to use cached queries to make the performance
better. However, if I use cached queries and an admin user goes into
the backend and adds a new article, then goes and views the front end,
he won't see the new update automatically, right? How could I (in my
admin code) "flush" the cache for that particular query or set of
queries?
>From what I've gathered from previous posts on the list about caching
queries in CF, the cache depends on the exact sql syntax and the
application name...I think. Is that correct? Any tips on how to
optimize my queries for fast caching while also being able to update the
live site immediately with new info inserted through CF on the backend
would be extremely helpful! Thanks!
John Burns
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
