Heh heh, the ol' transposition error. Duh!
> -----Original Message-----
> From: Steve Nelson [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 10:57 AM
> To: Fusebox
> Subject: Re: Refreshing a cached query
>
> 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
