Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

>Yes, with enough finagling, sharp application programmers (is this an
>oxymoron?...he says...ducking for cover...) can reduce locking
>contention within pages, perhaps to the point of tolerability in a large
>OLTP system.

1 - I've never been involved in an OLTP system that had a problem with page vs row level. The largest one so far was 25GB OLTP, 250 users. No deadlocks, no hairy training of programmers, just normal understanding of set theory and transactions.

2 - On the minus side of row locking, it encourages developers to continue with a record oriented mentality instead of a set mentality. An example is Oracle's row_id. I've seen this on every Oracle project, i.e. the shortcut is taken instead of thinking the set operation through properly.

Gary Received on Wed Nov 26 1997 - 00:00:00 CET