[thesite] Caching

[.jeff]

matt,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Warden, Matt
>
> > agreed, though i'd prefer it was automated.  having it
> > automated means it would happen even for those
> > activities completed by a non-admin as well as not
> > requiring any documentation -- it'd just work.
>
> the point was a quick solution that would help me see
> how to do refreshing of the cache. then i'd try to
> stick it into the verious processes to automate it.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

i believe that it's as simple as running a query by the same name as the one
that's cached that you want to refresh.  so, the query on the homepage that
retrieves all the articles could be refreshed in any template that adds or
updates comments, ratings, or content simply by running a query of the same
name:

<cfquery name="articles" ...>
  SELECT 1
    FROM content
   WHERE 1 = 0
</cfquery>

(is that just about as bogus a query as you wanna get?)

the trick will be going straight to the homepage and seeing if the query is
actually re-running from the database or from the cache.  if my
understanding of query caching is correct, then it should grab a new copy of
the data to cache.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/