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

>Sorry, but I've seen page locking problems in OLTPs, usually because of >multi-part transactions on POS (Point of Sale) systems. Sounds like a case of incomplete design, but I wasn't there. My point is that there is nothing in PLL or RLL that guarantees a database problem with incomplete requirements, poor forethought, bad design, qucikie development, etc. >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. I've never designed or been a participant in a system that had any significant contention. If that makes me naive in you book, so be it. Gary