Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tx isolation
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?
-- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.comReceived on Mon Dec 02 2002 - 00:40:10 CST