I would have thought that once you changed the clientstorage attribute, either globally through the administrator or within the cfapplication tag, that CF would henceforth ignore the previous storage site and leave the orphan client variables to gather dust. Are you saying that CF will inspect all registered client storage options (from HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\ClientStores) and continue to purge old entries using either the default timeout or an override? I experimented with a custom tag once that claimed to clean out the registry and it left a lot to be desired...
Thanks! Chuck McElwee etech solutions inc www.etechsolutions.com -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:59 PM To: CF-Talk Subject: RE: Client Var Registry Values > I'm changing all my servers to store client vars in a > SQL 2k DB. > > 1) How/where/what should i clean out of my registry when > it's complete You can just leave this alone, and CF will purge it when it's no longer valid. It won't affect your applications once they've been pointed to the new repository. > 2) In one scenario, my SQL Server is a separate machine. > The webserver and SQL box in this scenario are connected > DIRECTLY via a second network card in each machine. Is > this sufficient enough for Client Variable storage, or > should I install SQL server on the web server to handle > the variables? You don't want your database server running on your application server if you can avoid it. Having a fast dedicated connection is a good idea, but even without that, you'd still want your Client variables stored on your database - just make sure that you've indexed the CDATA and CGLOBAL tables appropriately. You may also have to programmatically purge your tables, though; I've run into cases where that didn't happen automatically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
