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