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]
