Re: oracle - mysql comparison

VC wrote:

> A correct concurrency control/model ensures that all the permitted
> transactions are serializable. In this sense, databases like DB2 or MSSQL
> implement a correct concurrency model albeit at the expense of lower
> concurrency in some circumstances. Funnily enough, none of the Oracle
> isolation levels can make the same promise, i.e. ensure serializable
> transaction histories, in any of its isolation levels. Usually, it's quite
> easy to obtain correct results by augmenting an isolation level with
> something like 'select for update', though..

And if this is true why, exactly, would anyone care at the expense of being able to extract an accurate answer from a database without performing table locks on all resources?

Daniel Morgan Received on Thu Jul 15 2004 - 21:34:19 CDT