Re: SQL Server vs INFORMIX
On 08 Oct 1997 08:37:08 -0600, Pablo Sanchez <pablo@engr.sgi_xyzzy_com> wrote:
>>>>>> ""Billy" == "Billy Wheeler" <billy@west.co.za> writes:
>Billy>
>Billy> Some notes on this:
>Billy> 1. Richard also forgot the problem applies to
>Billy> INSERTs, which in an OLTP system can be even worse.
>Billy> 2. RDBMS's which don't support row level locking
>Billy> *do* all suck. 3. It wasn't really a deliberate
>Billy> decision to apply page level locking for
>Billy> performance, I just forgot to alter the tables after
>Billy> our initial dbexport/dbimport.
>Billy>
>
>One question: who owns the current TPC-C record? I'll make
>it easier for you: it's not Informix nor Oracle.... and
>they do page level locking.
(believe you meant row)
bzzt. wrong answer.... (couldn't resist).....
http://biz.yahoo.com/prnews/97/10/07/orcl_x000_1.html
Oracle Shatters All Existing TPC-C Benchmarks
Oracle8(TM) and Sun Ultra Enterprise 6000 Cluster Benchmark Set New World Record
of 51,871.62 tpmC at $134.46 per tpmC
Thomas Kyte
tkyte@us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation