Re: Microsoft destroys TPC-C records!

From: Norris <jcheong_at_cooper.com.hk>
Date: 2000/04/07
Message-ID: <8ckua9$2hl5$1@adenine.netfront.net>#1/1

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. Received on Fri Apr 07 2000 - 00:00:00 CDT