Re: Concurrency in an RDB

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 14 Dec 2006 15:30:40 GMT
Message-ID: <A6egh.32834$cz.488675@ursa-nb00s0.nbnet.nb.ca>

Christopher Browne wrote:

> 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?
>
> I seem to recall there being some anomalies where, if locks get
> released, it gets easier for deadlocks to occur...

Well, I suppose never releasing any locks might reduce deadlock, but I think it would greatly increase the starvation problem. Received on Thu Dec 14 2006 - 09:30:40 CST