Christopher Browne wrote:
>
> On Mon, 19 Oct 1998 21:40:02 +0000, Evan Carew <ecarew@yahoo.com> wrote:
> >In response to your functionality requirements, watch out for
> >row-level-locking. This feature was resisted for years in Sybase for
> >good reason, it sucks. Row-level-locking has been known to cut the
> >performance of an otherwise zipy Oracle server down to glacial speeds.
> >Generaly speaking, row-level-locking is regarded to be a design flaw
> >anyway, so you probably don't want to rate that feature too highly.
>
> And, on the other hand, trying to have large numbers of processes update
> DBs in the *absence* of row-level-locking can also 'suck badly.'
Sad since Informix Dynamic Server's performance with row level locking
is just fine. I have to work at a benchmark that can show a difference
in performance from tables with page level locking clearly. Well, with
luck IDS for Linux will be out soon and the world can play with our
favorite database and see what REAL software can do.
Art S. Kagel