I concur with Nat. About eight months ago, on this very list, I asked about
client variables and complex structures. I had an app with some pretty hairy
structures, including an array of structures which was a sort of shopping
cart container. Everything was in session variables.
I set up a MS SQL 7 client variable store instead, and used WDDX to store
the complex structures. You know what happened? I actually had a tiny
performance increase!
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Nat Papovich [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 26, 2001 11:47 AM
> To: Fusebox
> Subject: RE: cflocation, addtoken = yes||no
>
> I'm going to HAVE to chime in here and muddy the waters for ya -
>
> Client variables have been measurably faster than session variables in
> tests
> I have run, using CF4.01 and SQL Server on the same machine.
>
> Now that that's a fully qualified statement, I'll let you make your own
> decisions, and run your own tests.
>
> NAT - Allaire Certified ColdFusion Developer
>
> > > Secondly how does it impact performance having to constantly update
> and
> > query a
> > > database.
> >
> > Yes, session variables are faster because you do not have to hit the
> > database to get at them, however the speed difference is
> > milliseconds which
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
