Re: Concurrency in an RDB

Christopher Browne a écrit :

> In an attempt to throw the authorities off his trail, Bob Badour <bbadour_at_pei.sympatico.ca> transmitted:
> > Transactions may acquire and release many locks over the duration of
> > the transaction which may be orders of magnitude longer than the
> > duration of any lock.
>
> Are you sure they ought to release them?
>
There is NO direct relationship between locks and deadlocks.

Behavior of locks is purely technology-and implementation-dependent. It is often a consequence of the RAM/disk swapping methodology used. Deadlock are mainly a result of strong contention preventing easy lock or metadata swapping... Received on Thu Dec 14 2006 - 17:17:12 CET