Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Db2, Oracle, SQL Server

Re: Db2, Oracle, SQL Server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Wed, 09 Feb 2005 17:22:30 -0800
Message-ID: <420AB756.6060302@comcast.net>


 > 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 Received on Wed Feb 09 2005 - 19:22:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US