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:354837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
