Re: tx isolation

From: KevJohnP <nospam_at_nowhere.com>
Date: Mon, 02 Dec 2002 22:03:13 +1300
Message-ID: <3DEB21D1.1010806@nowhere.com>

Hi Pablo

Have supported large OLTP systems with databases using both approaches and though as you imply developers can code around not being read consistent that doesn't mean they always do (or do so properly) or that it is a effective use of their time for them to have to. I have seen non-rc systems grind to a halt because one of the junior developers didn't understand the locking strategy.

Have also seen systems written with dirty / uncommitted read isolation level all over the application, I guess its those same lazy developers :), leaving the poor dba to try and explain the 'invalid' results returned to a query by the database.

For info, MySQL has now developed a rc option (though I haven't tested it) links are www.innodb.com or MySQL Max on www.mysql.com.

You are correct though, in that no it doesn't do the dishes in fact its record on all domestic chores is woefull (despite what the Oracle marketting people say) :)

KJP Pablo Sanchez wrote:
> KevJohnP <nospam_at_nowhere.com> wrote in news:3DEAC080.8020402_at_nowhere.com:
>
>

>>In the interests of balance, tried to find some Microsoft links that 
>>refute this.  

>
>
> Lock escalation issues are ... non-issues. Multiversioning is great
> but it also makes for lazy developers and the industry database
> benchmarks don't show that Oracle has any clear advantage.
>
> If one takes a gander at the current (12/1/02 @ 11:38pm MT) top 5
> clustered TPC-C by Performance, Version 5 results, the top three spots
> are owned by SQL Server 2000. Oracle 9i R2 takes the 4th and 5th
> spots.
>
> SQL Server 2000 tpmC: 709,220 <<<<----- Yeow!!!!!
> Oracle 9i R2 tpmC: 138,362
>
> One can look at the non-clustered numbers and there, Oracle 9i R2 looks
> more impressive. Nonetheless, SQL Server 2000 is up there as well.
>
> Bottomline: multiversioning is all marketing and it eats resources to
> boot.
>
> Does it do the dishes too?
Received on Mon Dec 02 2002 - 03:03:13 CST