I did exactly this on a site with news articles. You want to used
cached after with on the Articles query the date-time stored as an
application variable, e..g., Articles,CachedAfterDateTime,
When an admin updates an article reset the Articles,CachedAfterDateTime
variable to now() -- forces the next query to re-cache.
Simple, but works well!
HTH
Dick
On Apr 6, 2004, at 6:52 AM, Burns, John D wrote:
> 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]
