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