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 > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists