Re: Db2, Oracle, SQL Server

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 09 Feb 2005 19:26:57 -0800
Message-ID: <1108005849.281585@yasure>

Mark Townsend wrote:

> > You don't
>

>> want a "select" only system to take row locks all the time, because table
>> locks are much faster. Storing locks in memory is also faster than 
>> storing
>> them on the blocks.
>>

>
> Taking read locks at a table level: Faster
> Storing read locks in memory : Faster
> Not taking a read lock at all : Priceless
>
> Sorry. Couldn't resist

And you missed a good dinner too.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Feb 09 2005 - 21:26:57 CST