Thanks for the help, everyone. Adam, we have Client vars timeout after 20 days. We have had trouble with the purging in the past. Last time I looked I believe we had put in the hotfix for this problem and it was doing fine.
Matt -----Original Message----- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Sunday, January 16, 2005 5:32 PM To: CF-Talk Subject: Re: Database RAID Config w/Client Variables 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191285 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
