You may also see a slight performance boost if you change the data fields from text to varchar(max) if you are on sql 2005+, plus storage size is better. Pretty sure this was ok to do with CF8 plus.
Also be mindful of how much data you put into the client scope. Less the better, since every request will do a select and update of all data in the db regardless of any variables being updated in a request. Not sure if this is different with 10 since, we no longer use client, and have opted for sticky sessions in our cluster. I had a junior guy put a large wddx string into the client scope once (before we did better code reviews) and the instant the code was deployed killed our cluster. Byron Mann Lead Engineer & Architect HostMySite.com On Mar 5, 2013 4:23 PM, "Nick Gleason" <n.glea...@citysoft.com> wrote: > > Hi Folks, > We use client variables in our client databases and I've seen some > information that you can get better performance by creating indexes on > those tables. For instance this page > ( > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=sharedVar > s_08.html) says the following:"To improve performance, you should also > create indexes when you create these tables. For the CDATA table, index > these cfid and app columns. For the CGLOBAL table, index the cfid column." > Has anyone on this list created indexes for these tables before? If so, any > suggestions of the best way to do this? > For instance, would we need to add an identity column to these tables > first? If so, how best to do that given that they are in use with quite a > bit of data already. > Then, what would the actual index code look like? > Many, many thanks in advance. > Nick > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm