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