Re: ORACLE Sybase comparison

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?

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?

Chao Din Received on Sun Jul 07 1996 - 00:00:00 CEST