Re: Best database for web backend on Linux?

Christopher Browne wrote:
>
> On Mon, 19 Oct 1998 21:40:02 +0000, Evan Carew <ecarew_at_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 Received on Tue Oct 20 1998 - 00:00:00 CDT