Re: Concurrency in an RDB

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...

-- 
(format nil "~S_at_~S" "cbbrowne" "gmail.com")
http://cbbrowne.com/info/languages.html
Rules of the Evil Overlord #65.  "If I must have computer systems with
publically available  terminals, the maps  they display of  my complex
will have  a room clearly marked  as the Main Control  Room. That room
will be  the Execution Chamber. The  actual main control  room will be
marked as Sewage Overflow Containment." <http://www.eviloverlord.com/>