Re: Concurrency in an RDB

From: Cimode <cimode_at_hotmail.com>
Date: 14 Dec 2006 08:17:12 -0800
Message-ID: <1166113032.469596.104340@n67g2000cwd.googlegroups.com>

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 - 10:17:12 CST