Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Microsoft destroys TPC-C records!
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 said try it out yourself. With multiple concurrent updates and readers.
I don't give two hoots about commercial "benchmarks". Haven't you got that yet?
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html
Received on Sun Apr 09 2000 - 00:00:00 CDT