Re: Sybase vs Oracle - which is better?

From: Michael Bilhartz <bilhartz_at_newsguy.com>
Date: 1998/11/24
Message-ID: <73cm8a$a5o@enews1.newsguy.com>#1/1

Paul Mapstone wrote in message <365997B8.6B605638_at_t-mi.com>...
>> + Row level locking been for years in Oracle, only recently in
>> Sybase.
>I can honestly say I have not found the lack of row-level locking to be
>a problem. I suspect that this is more of an issue if an application
>has been designed for Oracle, then ported. On the rare occasions I have
>needed this, I have just padded the row so each fits on a single page.

The only place where I have ever found it to be a problem is sysobjects and syscolumns in tempdb. Row locking there would make DDL in transactions a lot more usable.

Regards,
-Mike Bilhartz Received on Tue Nov 24 1998 - 00:00:00 CST