This has been a thorn in my side for a LONG time. The problem with
setting it to zero is that it actually reruns the query instead of
offering a way to just remove the cached data. I've been begging
allaire to add this feature forever. The problem you run into is with
clustered servers. If you update data you have to remove the cached data
from all the servers in a cluster. Imagine if you had a cluster of 100
servers and the query you needed to update a single query that took 1
full second (say it was joining a bunch of tables with a lot of data).
That's a minimum of a minute and a half to perform a simple update
statement!!
Look at this: http://www.fusebox.org/theories/sync_server/
What's promising is TagServlet (http://www.tagservlet.com) i haven't
validated this, but supposedly they're implementation of the ColdFusion
language supports this feature.
Steve
BORKMAN Lee wrote:
>
> Hi Steve,
>
> You have to set the CACHEDWITHIN to zero, THEN run the query, THEN set the
> CACHEDWITHIN back to your original amount. Works like a charm.
>
> Let us know how it goes,
> Lee.
>
> -----Original Message-----
> From: J. Steven Tripp [mailto:[EMAIL PROTECTED]]
>
> I have cached a query using CACHEDWITHIN, but of course data changes and I
> need to unCache the query. How do I refresh a query? I read here that I can
> cut & paste it and set the time to 0, but that doesn't work. The fusebook
> says to go to the fusebox.org site, but there's nothing there about
> refreshing the query.
>
> IMPORTANT NOTICE:
> This e-mail and any attachment to it is intended only to be read or used by
> the named addressee. It is confidential and may contain legally privileged
> information. No confidentiality or privilege is waived or lost by any
> mistaken transmission to you. If you receive this e-mail in error, please
> immediately delete it from your system and notify the sender. You must not
> disclose, copy or use any part of this e-mail if you are not the intended
> recipient. The RTA is not responsible for any unauthorised alterations to
> this e-mail or attachment to it.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
