I worked on this and actually have a solution. It ain't pretty, but it
absolutely does work.
In a clustered server environment, such as mine, using Windows NT, you can
blow out a query's cachedwithin attribute by remotely writing to the
Registry on each server in the cluster.
The method I use is by no ways clean, but it is effective. There is a
command-line utility called REGINI that will allow you to do remote registry
edits. The trick is, hah, you need to build an .ini (or some such extension)
file that REGINI reads to process the edits.
My process works by writing the necessary batch files using CFFILE, then
executes 'em using CFEXECUTE. Of course, there is overhead with this
process, so the benefits might simply not be there if you are talking about
a 50ms query. BuTtTt, if you have some mondo query that takes a while to
execute, this tool will do the job in spades.
I've not used it in a while, but here it is:
http://www.anthc.org/skunkowkrs , and check out clust_qry.zip...
> -----Original Message-----
> From: Steve Nelson [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 7: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
