Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Microsoft destroys TPC-C records!
In comp.databases.sybase Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote:
> On 7 Apr 2000 15:19:37 GMT, Norris <jcheong_at_cooper.com.hk> wrote:
>>In comp.databases.sybase Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> 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 Received on Sat Apr 08 2000 - 00:00:00 CDT