Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Db2, Oracle, SQL Server
DA Morgan wrote:
> 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
Sorry. India. Received on Thu Feb 10 2005 - 09:43:29 CST