Re: ORACLE Sybase comparison

In article <31DFD7EB.71D7_at_csc.com> "Chao Y. Din" <cdin_at_csc.com> writes:
>Konstantin Ginzburg wrote:
>>
>> Ayokunle Giwa <akgiwa_at_cnct.com> wrote:
>> >Hi
>> > One big advantage Oracle has over the rest of the rdbms out there
>> >is row level locking I understand sybase only goes down to block locking
>> >Oracle afford higher granularity in terms of read concurrency and
>> >consistency .................................(*) (*)
>> > |
>> > < >
>> >
>>
>> My understanding is that higher granularity results in lower
>> speed (for simple selects anyways). Is it true?

Not a direct trade off, because you can still buffer pages of data. With Oracle's locking scheme, it's less of an issue than other db's, too. With any scheme, you can manufacture a losing situation.

>
>I may be naive, but ...
>
>Row level lock is part of SQL standard. It is hard to imaging that
>Sybase is not an ANSI compliant database. Can a Sybase guru help me on
>this?

You might ask that in a Sybase group. All commercial implementations of SQL vary from or extend the standard, so they can be useful in the real world.

>
>Chao Din

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O