Re: Microsoft destroys TPC-C records!

On 5 Apr 2000 01:59:17 GMT, Norris <jcheong_at_cooper.com.hk> wrote:

>See the Locking differences between Oracle and SQLServer
>http://www.microsoft.com/sql/productinfo/transadvantage.htm
>

OK, let's give it a try....

( - Provides higher accuracy with its "writer-blocks-reader" behavior.)

The example provided of the husband-wife is completely FALSE and MISLEADING. It is NOT what ORACLE does.

( - Optimizes system resources through the use of dynamic locking. )

Cripes, what a load of rubbish. When a design decision has been taken because it's too hard to write the appropriate code, let's resort to the "engine knows better" explanation. Gives it the "aura" of mistery all ignorants like.

EXACTLY what Ingres used to explain their half-baked row-locking design. Which never worked.

Why did I bother? I KNEW I was wasting my time...

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Apr 05 2000 - 00:00:00 CDT