Hmm.. That's good for a single-question poll. But what about something like that as a "Survey"?
| -----Original Message----- | From: Gene Kraybill [mailto:[EMAIL PROTECTED]] | Sent: Monday, October 14, 2002 12:43 PM | To: CF-Talk | Subject: Poll | | | Someone (sorry, I deleted the msg) was asking about a poll. | Here's a freeware one on Dev Ex... | | http://devex.macromedia.com/developer/gallery/info.cfm?ID=6A94 | 8CFB-C9E9-11D6 | -840900508B94F380&method=Full | | Gene | | -----Original Message----- | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] | Sent: Monday, October 14, 2002 3:28 PM | To: CF-Talk | Subject: Re: Client Variable Storage and SQL Server | | | Yep, afaik CF ( at least prior to MX ) hits the db for each | reference to those client variables... If you're concerned | about the overhead, you could copy all your client variables | to the request scope at the top of the page, i.e. in your | application.cfm and then use the request variables instead... | | <cfloop index="x" list="#getclientvariableslist()#"> | <cfset request["c_#x#"] = evaluate("client.#x#")></cfloop> | | Once you've got this in your application.cfm a multi-file | regex or two on your development directory should get the | rest of the app in line with this structure... | | If you use lots and lots of client variables or have many | pages on which they are not used, however, this might wind up | being less efficient than simply using them normally the way | you are now, since this would copy all your client variables | to the request scope whether they're used on a page or not. | | The other alternative of course, is to simply manually | optimize each page by copying any client variables which are | used more than once on that page into the request scope at | the top, thereby grabbing only the data that page will need. | | My own applications only reference them once or twice on a | given page, so I don't worry terribly much about their | management or overhead. | | | hth | | S. Isaac Dealey | Certified Advanced ColdFusion 5 Developer | www.turnkey.to 954-776-0046 > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
