Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Date: 1997/12/03
Message-ID: <664b0o$t8c_at_mtinsc04.worldnet.att.net>#1/1
Pablo Sanchez wrote:
> For a finely tuned application, row level locking
> does *not* matter.
To fine tune application to avoid any major deadlock as a developer, you
need a lot of experience with how SQL server and database works. With
row level locking capability, it makes things a lot easier cutting many
development hours.
Arguing which is better row level vs. page level is silly as an
experienced database developer/dba because we know better. I think that
both Sybase and MS will/have come up with dynamic locking capability in
current/future releases.
Insisting on one will cost you either performance or extra codes to
prevent deadlocks.
> --
> 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 ]
-- Jay Lee Lake Mary, FLReceived on Wed Dec 03 1997 - 00:00:00 CET