> It's a little strange because since the indexing is handled automatically it > isn't obvious how optimized the processes are. Has this ever been a > bottleneck for scalability?
Matt, I've run traced load tests on an isolated client variables database (i.e., separated from the transactional DB) with production-scale data, and the three non-clustered indexes that are created on the CDATA and CGLOBAL tables are about as efficient as can be. Post-test analysis didn't suggest any changes to the indexes in any way. The rows themselves appear to be retrieved as efficiently as possible. The only real bottleneck seems to be deserializing the key-value pairs back into Client variables once the text columns containing them are passed to ColdFusion on each retrieval. I didn't thoroughly read through all the earlier posts in this thread, but are you expiring your Client variables after one day rather than the default 90 days? Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Studio MX from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=50 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54