> 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 ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
