After discussing it at great length with my DB boy, and relaying those
opinions to Alaska Alan, he (Alan) is building a prototype of this concept.
Stay tuned.
Nat "Frames are cool, dude" Papovich
ICQ 32676414
-----Original Message-----
From: Steve Nelson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 10:08 AM
To: Fusebox
Subject: Re: cf_queryrefresh
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.
------------------------------------------------------------------------------
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.
