Re: Microsoft destroys TPC-C records!

That is the point:

With page-, multiple page-, and table-level locking, fewer system resources are used than with row-level locking.

SQL Server is designed to AUTOMATICALLY maximize the trade-off between concurrency and performance and system resources, to give the optimal level of lock specificity (row, page, multiple page, or table) for all database operations.

Of course, you can MANAULLY speed up the operation.

In comp.databases.sybase Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote:

> BTW, you don't HAVE to place 1 million row-locks in ORACLE. Although
> you'd be surprised how fast that is versus how slow in sql server.
> Another falacy caused by "reading the manuals".

> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html

-- 
http://www.cooper.com.hk