Re: How to handle deadlocks ?

Joe Lumbley wrote: > > Joachim Achtzehnter (joachim@softouch.bc.ca) wrote: > : bgw@world.std.com (Bruce G Wilson) wrote: > > sybase seems to have more of a deadlock problem than Informix. I believe it > is because they lack row-level locking. I've seen deadlocks occur even though > the transactions are short and the locking order is the same. In sybase, > these locks seem to be page 0 locks (whatever that is). Even still, your database de jour should allow for timeouts. So, if you hold some resources while waiting for another, if you time out before you get the next resource, you roll back and release your resources. -Mikey