You can always check off the "Disable global client variable updates" box for the client store, if desired, so that they only get updated when you explicitly do it.
In past testing I've found that using db client variables on our servers added roughly 15ms overhead to the request. Not enough to worry with given the benefits they offer. Ken -----Original Message----- From: Gaulin, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:30 PM To: CF-Talk Subject: RE: Client Variable Storage and SQL Server Hi Andy Yes, this is real, and we stopped using client variables because of it. I suspect that most of the load is spent updating the last-time-someone-visited-the-site information in the database tables... it has to do this on every hit, whether or not the client even has any client variables. (That information is probably used to purge variables from the database at regular intervals.) Their implementation strategy makes sense, it just generates lots of db accesses and, potentially, lots of db writes. Mark -----Original Message----- From: Andy Clary [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 1:13 PM To: CF-Talk Subject: Client Variable Storage and SQL Server We are using SQL Server to manage our client variables and I've noticed that a majority of the SQL commands hitting our server are from Cold Fusion managing client variables. Has anyone else noticed this type of activity? Just a simple trace in SQL Profiler revealed statements like: SELECT data FROM CGLOBAL WHERE cfid = @P1 or exec sp_executesql N'SELECT data FROM CGLOBAL WHERE cfid = @P1', N'@P1 char(13)', '4858:66043525' I haven't measured this in terms of performance, but I imagine it has to take some toll on our server. Is this the best way to go or should I try something else? Thanks in advance, Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
