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.

Sorry, but I've seen page locking problems in OLTPs, usually because of multi-part transactions on POS (Point of Sale) systems.

Yes, there are workarounds. One system supports more than 700 concurrent users, but it takes a lot of forethought to make sure that different inventory items don't share a page. During the Christmas rush, it is naive to think that there won't be contention between users for a single page of data.

-- 
Peaches	  http://miso.wwa.com/~fsgchi 
	  reply to: fsgchi at wwa dot com
What lies before us, and what lies behind us, are tiny matters
compared to what lies within us...	--Ralph Waldo Emerson