Sorry, you're correct. You would need a composite primary key in CDATA, on cfid & application. A primary on cfid alone on CGLOBAL should suffice since it contains the lastvisited and hitcount values for the entire server.
Chuck McElwee etech solutions inc www.etechsolutions.com -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:40 PM To: CF-Talk Subject: RE: Client Var Registry Values Chuck wrote: > I think what you want to do is simply make the cfid column in > both CDATA and CGLOBAL the primary keys for those tables. On my dev server I have three records in the CDATA file right now: CFID APP DATA ------------------------------ 8:1618725 PI_2k2 (cvars go here) 8:1618725 MYapp (cvars go here) 8:1618725 Test030602 (cvars go here) A primary key on the CFID would limit me to one cfapplication name per server. You have to use a simple index. The way I have mine set up, the CFID fields just get a normal index in both files. I think I could go primary key for CFID in CGLOBAL, but its operated like this for quite some time with no problems. --Matt-- ______________________________________________________________________ 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
