Stewart, Just engineer client variables out of your application altogether. Why exactly are you using them?
Respectfully, Adam Phillip Churvis Get advanced intensive Master-level training in C# & ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com -----Original Message----- From: Stewart Turnbull [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 9:56 AM To: CF-Talk Subject: Separate DB for client vars? I'm looking at things to speed up a CFMX7 application and was wondering if creating a separate MS SQL 2000 DB only to hold the application's client vars was worth considering? Although the 2 tables CDATA and CGLOBAL are purged every 2 days both tables contain of 60,000 records. I suppose if nothing else it would make the applications DB backup slightly smaller. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
