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 Get the mailserver that powers this list at http://www.coolfusion.com