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_at_ursa-nb00s0.nbnet.nb.ca>
>
> 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...
Date: Thu, 14 Dec 2006 15:30:40 GMT
Message-ID: <A6egh.32834$cz.488675_at_ursa-nb00s0.nbnet.nb.ca>
>>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 - 16:30:40 CET