In addition to what Jon suggested you may want to consider implementing the UUIDToken solution described here: http://www.macromedia.com/v1/Handlers/index.cfm?ID=22427&Method=Full
It helped our site when we were seeing Session/Client variables being improperly "shared" by different users as you describe. Note that it requires some changes to the CFID field in order to hold the longer token. I have made those columns VARCHAR(70) and it seems to be long enough. </rob> -----Original Message----- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:42 PM To: CF-Talk Subject: RE: deadlocks in CFGLOBAL Thanks, I didn't realize that's all it was storing in CGLOBAL :) -----Original Message----- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:38 PM To: CF-Talk Subject: Re: deadlocks in CFGLOBAL Client variables use a cookie to look up the client value from the database, so it is possible and I imagine cfglobal table gets a lot of Update or Select/Insert (I'm not sure how CF handles updating that table) queries under load. You might want to go into the CF admin and just disable global client variable updates, in the client variable section if you dont use the stats CF keeps about last visit's and hitcounts. Disabling the global stats is SOP here. You will probably notice an overall performance boost as well... jon ----- Original Message ----- From: "Hoag, Claudia (LNG)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 12:02 PM Subject: deadlocks in CFGLOBAL > Does anyone know why I get row level deadlocks in CFGLOBAL and what are the > implications of that? > The other day I talked to our DBA about some deadlocks (not related to > CFGLOBAL) and she started to look for them... And found a whole bunch of > deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't > start looking for them, I would never take notice that those were happening. > I wonder if that has anything to do with users complaining that their client > variables are getting mixed with other users' client variables. I can't see > how that would happen, considering that the client variables rely on a > cookie set for an individual browser... Any ideas? > > TIA, > Claudia > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
