Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Date: 1997/11/21
Message-ID: <yutsosqcpof.fsf_at_mew.corp.sgi.com>#1/1
[ this message is so old ... ]
>>>>> "Chris" == Chris Jenkins <chrisj_at_informix.com> writes:
Think again. Look at the current -C values for Sybase and
look at what Informix is generating. Sounds like you fell
for that one too...
I don't think so... common sense dictates that there be
overhead via your lock manager. More locks, more overhead.
Anyway, this is a futile discussion because it's been hashed
out over and over and over and over again...
Chris>
Chris>
Chris> Sorry but it is a *big* limitation. Row level locking provides much greaterconcurrency,
Chris> even for a well designed application database.
Chris>
Chris> The only reason that the default is page level locking is historical. It usedto be that
Chris> way so we haven't changed the default to maintain backwards
Chris> compatibility. We always encourage use of row level locking these days.
Chris>
--
Pablo Sanchez | Ph # (650) 933.3812 Fax # (650) 933.2821
pablo_at_sgi.com | Pg # (800) 930.5635 -or- pablo_p_at_pager.sgi.com
-------------------------------------------------------------------------------
I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]
Received on Fri Nov 21 1997 - 00:00:00 CET