There is a Ms sql server bug, that can cause this, on a CPU 1+ box. There are a few work arounds. Otherwise its transactions, make them as short as possible. Check
http://support.microsoft.com/default.aspx?scid=kb;EN-US;315662 http://support.microsoft.com/default.aspx?scid=kb;en-us;317821 HTH Justin -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 14:23 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] sql deadlocks Hmm, having some trouble with some forums I've got that are getting busy. Occasionally I'll get deadlock error messages back from odbc about the fact that the process I'm using was chosen as the victim of a deadlock. How can I avoid these? The site is on a fairly cheap shared setup, so can't change the hardware etc.. ------------------------------------------------------- Rich Wild Senior Web Developer ------------------------------------------------------- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
