Re: lies damn lies and benchmarks

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 09 May 2002 15:35:03 GMT
Message-ID: <3CDA971D.87DA9797@exesolutions.com>

Chris Weiss wrote:

> Hmmm.... It seems that like in many product wars, people's knowledge is out
> of date:
>
> * Sql server had had robust row level locking since version 7. Prior to
> this it was page locking, which could be clumsy.

This is only partially true. It is still quite easy to run out of row leve locks in SQL Server and have the row level locks escallate to page level locks. And even if one doesn't there is no equivalent to multiversioning.

Page level locking, and lock escallation are both alive and well in SQL Server and absolutely non-existent in Oracle.

One example of how this impacts development is the need in SQL Server to create on-the-fly temp tables, break up transactions, and perform frequent commits, in order to avoid over-extending the resource.

Daniel Morgan Received on Thu May 09 2002 - 10:35:03 CDT