I knew you'd appreciate it, Nat. After all, anybody who digs db-stored
client variables can't be all that bad. But what's up with the frames thing?
That's just weird, heh heh.
But I do believe my scheme would work. I mean, hey, the db-stored WDDX
structure thing worked, right? Y'all can read it in the October CFDJ...
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Nat Papovich [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 21, 2000 8:25 AM
> To: Fusebox
> Subject: RE: cf_queryrefresh
>
> Alan, this is RAD! I bet this can work. The only question is whether or
> not
> those chronic cfregistry reads are fast. In fact - they are! I just did
> this
> test:
>
> test1.cfm:
> <cfregistry action="SET" branch="hkey_local_machine\software\allaire"
> entry="AlansTest" value="1">
> <a href="test2.cfm">Test2</a>
>
> test2.cfm:
> <cfset start=GetTickCount()>
> <cfloop from="1" to="1000" index="count">
> <cfregistry action="GET" branch="hkey_local_machine\software\allaire"
> entry="AlansTest" variable="test">
> <cfoutput>#test#</cfoutput>
> </cfloop>
> <cfoutput>#Evaluate(GetTickCount()-start)#</cfoutput>
>
> It reads the variable from registry and outputs it's value 1000 times in
> 180-190 ms. That's on my development workstation, not a real server.
> That's
> 0.19 ms per read! Rock on, Alan.
>
> Somebody set this puppy up for real and we'll have a clustering query
> refresh solution yet!
>
> Nat "Frames are cool, dude" Papovich
> ICQ 32676414
>
>
> -----Original Message-----
> From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 21, 2000 8:27 AM
> To: Fusebox
> Subject: RE: cf_queryrefresh
>
>
> 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.
