Re: Db2, Oracle, SQL Server

From: Mark A <nobody_at_nowhere.com>
Date: Mon, 7 Feb 2005 19:56:35 -0700
Message-ID: <EaSdnSN3C_FptJXfRVn-pw@comcast.com>

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
> Define "large load".
>

How about the TPC-C benchmark where DB2 has posted 2.5 times the transaction rate of the next closest competitor:
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp

> >
> > Why keep pushing this issue (its really a non issue) when it has
> > already been explained?
>
> Because it has not been explained, and some
> ignorants keep insisting that lock escalation is scalable.
> When it isn't, it never was, and never will be.
>

No, what was said is that by changing a few parameters it is easy to Completely avoid lock escalation. But if you have a data warehouse database (that benefits from lock escalation) you can set the parms to encourage lock escalation. It is up to you. Received on Mon Feb 07 2005 - 20:56:35 CST