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

Gary Kuever wrote:

> 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.

	Precisely. I see this a lot with products designed for any backend.
	The unfortunate thing is that usually the wrong backend is chosen
	for development. The end results are well known.

-am Received on Thu Nov 27 1997 - 00:00:00 CET