Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Date: 1997/12/04
Message-ID: <668a3r$eno_at_dfw-ixnews10.ix.netcom.com>#1/1
>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 Received on Thu Dec 04 1997 - 00:00:00 CET