Thursday, 28 April 2016

Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock

 

On Thu, Apr 28, 2016 at 11:39 AM, Ann Harrison <aharrison@ibphoenix.com> wrote:

A lot of stuff including: 

In ancient history, even in read-committed mode, Firebird blocked transactions from updating records if the most recent version was created by a concurrent transaction.  At the time, we considered anyone who liked inconsistency not worth worrying much about.  It was a long time ago.  

Or maybe not.  I mentioned this thread to Jim who's creating yet another databases thirty-plus years after InterBase.  His reaction?  "Read committed is flawed in premise.   You can reach any conclusion from a flawed premise."  

Cheers,

Ann

__._,_.___

Posted by: Ann Harrison <aharrison@ibphoenix.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (13)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment