You could use a named lock to single thread the code which inserts the new message, with a high time out?
Kola >> -----Original Message----- >> From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- >> [EMAIL PROTECTED] >> Sent: 17 October 2003 15:50 >> To: '[EMAIL PROTECTED]' >> Subject: RE: [ cf-dev ] sql deadlocks >> >> Before any SQL hints can be applied its best to try and see where the >> lock >> is occuring and on what spid. use sp_lock to get a clear idea of where >> the >> lock is occuring and what type of lock it is, then we can see where or >> how >> to prevent them using SQL Hints.... >> >> Port you output.. >> >> -----Original Message----- >> From: Rich Wild [mailto:[EMAIL PROTECTED] >> Sent: 17 October 2003 15:44 >> To: '[EMAIL PROTECTED]' >> Subject: RE: [ cf-dev ] sql deadlocks >> >> >> Its not about the 2 pages, thinking about it, its just the one that adds >> posts - I've got too many users runing that page at the same time, and >> the >> sql server is deadlocking them. Obviously the sql server is locking the >> entire table, as other users can't add new rows at the same time as >> another >> user. >> >> All I have is a single simple cfquery INSERT. Nothing odd about it - its >> not >> trying to do anything fancy. >> >> The forum is experiencing high traffic - which is causing this. >> >> > -----Original Message----- >> > From: Justin [mailto:[EMAIL PROTECTED] >> > Sent: 17 October 2003 15:42 >> > To: [EMAIL PROTECTED] >> > Subject: RE: [ cf-dev ] sql deadlocks >> > >> > >> > >> > Post the code? Justin >> > >> > > I have 2 pages - one to add a post to a thread and another >> > to select >> > > the entire thread and display it. >> > >> > >> > -- >> > ** 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] >> >> -- >> ** 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]
