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

Posted in 1997

Topics: Performance & Tuning, Server Administration, Transactions, Locking & Isolation

Jung S. Lee — Wed, 03 Dec 1997 14:13:29 -0500 — source: Informix-list mailing list archive (1991-1998)

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@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 ] -- Jay Lee Lake Mary, FL