I've done that Kola - it doesn't work. I'm currently running a trace on the server - but it doesn't help that the trace keeps sapping all the power out of the server, preventing sites on the CF box from accessing data..
It's a very busy box... > -----Original Message----- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED] > Sent: 17 October 2003 16:01 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] sql deadlocks > > > > 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] > -- ** 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]
