oh wait.... i see where you're going. That is pretty cool.
Let's get this idea hammered out and publish an example of using it. We
should also look at various speed issues, like is the registry the way
to go or should it be stored in a database?
Steve
"McCollough, Alan" wrote:
>
> I think there might be an easier solution, but it is based on using a 100%
> Microsoft solution...
> Lets say you've got an NT server cluster, complete with an MS SQL 7 server
> in there.
>
> In your fusebox code, you create a var called, oh, db_timespan. Now, here's
> what to do. Have this var live up in app_globals.cfm, so it gets called
> persistently. But you set the variable by doing a CFREGISTRY read, and let's
> say you've got a Registry key called "{blah blah}\db_timespan". You could
> use the value in this var to change the CACHEDAFTER or CACHEDWITHIN values
> of a query, depends on what ya want to do.
>
> If you want to keep different timespans for different queries, you'd just
> set up additional Registry keys.
>
> So okay, follow with me, you've set this var up so every time app_globals
> gets called, you do a registry hit and get the new value. So what?
>
> I've found out you can do some mega-cool stuff with batch files in NT,
> including changing registry settings on remote boxes. Uh, huh, you see the
> idea coming together.
>
> For each "db_timespan" variable you have, you write a batch file that goes
> out and updates the Registry keys for those time vars on all the CF servers
> in your cluster; resetting the time to zero so as to force a fresh query.
> You make sure this batch file is installed on each server in the cluster so
> that any node on the cluster can execute the batch file.
>
> Now, you have two avenues you can take. The obvious one is to use CFEXECUTE
> to call the batch file whenever you run a Insert/Update/Delete query. The
> batch file gets called, and, ta-da, there ya go.
>
> The other solution, with its own benefits and caveats, is instead of housing
> the batch files on the CF boxes and using CFEXECUTE, use your SQL server and
> create a trigger for any Insert/Update/Delete actions. The trigger would
> then start a XP_CMDSHELL extended stored proc (thats pure MS SQL, folks; it
> ain't gonna be available elsewhere) to call the batch file.
>
> Alan McCollough
> Web Programmer
> Allaire Certified ColdFusion Developer
> Alaska Native Medical Center
>
> > -----Original Message-----
> > From: Steve Nelson [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, September 21, 2000 3:46 AM
> > To: Fusebox
> > Subject: Re: cf_queryrefresh
> >
> > The tag is not worth it. All it really does is set the timespan in the
> > cachedwithin attribute to #createtimespan(0,0,0,0)# when you set
> > attributes.refresh="yes"
> > #createtimespan(1,0,0,0)# when you set attributes.refresh="no" I was being
> > lazy when i wrote that. At the time i hadn't thought up what happens when
> > you have clustered servers.
> >
> > A much better solution is doing a thing I call the "Synchronization
> > Server". This will allow you to keep multiple clustered servers in Sync.
> > It's still just a theory, but if it
> > actually works we'll have a session on it at the next Fusebox conference,
> > because it is way cool.
> >
> > http://www.fusebox.org/theories/sync_server/
> >
> > Steve Nelson
> >
> > "Andrew Sleigh (Worth Media)" wrote:
> >
> > > Does anyone know where I can get hold of the <queryrefresh> tag that
> > Steve
> > > Nelson mentions in his spec on fusebox.org?
> > >
> > > the URL is
> > >
> > >
> > http://www.fusebox.org/specifications/largescale/index.cfm?fuseaction=quer
> > yf
> > > iles
> > >
> > > but the link seems to have died....
> > >
> > > Andy
> > >
> > >
> > --------------------------------------------------------------------------
> > ----
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
> >
> > --------------------------------------------------------------------------
> > ----
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
> ------------------------------------------------------------------------------
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
