Re: Microsoft destroys TPC-C records!

In comp.databases.sybase Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote: > On 8 Apr 2000 15:25:05 GMT, Norris <jcheong_at_cooper.com.hk> wrote:  

>>>>> As I said: get a copy of ORACLE, and check out how MS's claim that row
>>>>> locking slows down large updates is totally FALSE. Don't confuse MS's
>>>>> crap implementation of row locking with what can be done. And has
>>>>> been done in ORACLE.
>>>>
>>>>I have tested out the update benchmark in my NT with Oracle, MSSQL, Sybase, DB2 and Informix. I don't have CA Ingres on NT. I found that ASE updates table very fast. I think Adaptive Server uses in-place direct update technique. I don't know if it is related to locking.
>>>>
 

>>> Again you miss the point, Norris.
>>> It's NOT the speed, it's WHAT HAPPENS when two, three,etc users update
>>> and read off the same table at the same time. Same rows, different
>>> rows, etc,etc. It's really not that hard to setup and test.
>>
>>Would there be any differences if I use 36 client user machines like TPC-C benchmark done by Compaq?
>>
>>http://www.tpc.org/new_result/c-result1.idc?id=100021702
>>
 

> Last try, Norris. You're getting really tiring with your monotonous > parroting of URL's.

I am not an Oracle Certified DBA and I don't know how to do it. Received on Sun Apr 09 2000 - 00:00:00 CDT