I think what you want to do is simply make the cfid column in both CDATA and CGLOBAL the primary keys for those tables.
Chuck McElwee etech solutions inc www.etechsolutions.com -----Original Message----- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:59 PM To: CF-Talk Subject: RE: Client Var Registry Values Thanks a lot! I appreciate. Any good links/locations for proper fields in those tables to index? - j -----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
