Am I dreaming or do I remember Allaire mentioning that the cluster. scope
variable was going to be available in CF 5 or Neo? Wouldn't that just be da
bomb?
NAT
> -----Original Message-----
> From: Steve Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 8:44 AM
> To: Fusebox
> Subject: Re: Refreshing a cached query
>
>
> 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
