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

Gary Kuever wrote:
>
> >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.

	Now here's an example of someone who knows how to think,
	and not only that, has the experience to recognise the issues.
	Gary, I tip my hat to you.



> >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

	I've worked on a system recently where there used to be contention,
	but I was able to resolve the problem with rather trivial
	changes. Its just as you said Gary - poor forethought, bad
	design, etc. Luckily, I was able to recognise this and identify
	the correct solution and enact it. It isn't exactly hard.
	So why do some of the participants in this debate seem to
	think so?

-am Received on Fri Dec 05 1997 - 00:00:00 CET