I think you meant: http://www.anthc.org/skunkworks/
Steve
"McCollough, Alan" wrote:
>
> 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
