Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

[ this message is so old ... ] >>>>> "Chris" == Chris Jenkins <chrisj@informix.com> writes: 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> 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... 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> 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... -- Pablo Sanchez | Ph # (650) 933.3812 Fax # (650) 933.2821 pablo@sgi.com | Pg # (800) 930.5635 -or- pablo_p@pager.sgi.com ------------------------------------------------------------------------------- I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]