From: "Chao Y. Din" <cdin@csc.com>
Subject: Re: ORACLE Sybase comparison
Date: 1996/07/07
Message-ID: <31DFD7EB.71D7@csc.com>#1/1
references: <a44398.72.009BFC31@it2.eskom.co.za> <4r9ja3$m8a@mars.cnct.com> <4rbrmb$jku@news.mr.net>
content-type: text/plain; charset=us-ascii
organization: Computer Sciences Corp.
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 2.02 (Win16; I)



Konstantin Ginzburg wrote:
> 
> Ayokunle Giwa <akgiwa@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