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

Cosmo Lee wrote:
>
> Pablo Sanchez wrote:
>
> > 2) Row level versus page level locking is all marketing hype
 

> > crap. If you want to believe, go for it... but look for
> > the problems in your application, not at the RDBMS
> >
> > Ultimately, people believe what they want to believe... this
> > argument is so old... yawn.
> >
>
> You're really are quite wrong on this issue. There are applications where anything
> other than row level locking simply won't do. It's not all hype.

	Since when? Whenever I've come across third party applications that
	depend on row level locking and have been ported to Sybase, the
inevitable
	problems that ensue are simply because the applications are so badly
designed
	to be laughable. I'm struggling with one such in particular at the
moment
	called Aurion. But it might as well be SmartStream, SAP or PeopleSoft
or
	whatever. They claim they need row level locking because they all
stupidly
	lock selected data for the duration of a transaction that may or may
not
	utilmately do an update or insert. The changes to correct this sort of
	nonsense are trivial. Why they won't do the change is obvious. These
	programs cater to the lowest common denominator in database technology.
	Thus they don't have a real grasp of proper client/server methodology.

> The fact that
> you are making such a broad sweeping general statement should clue you in to to the
> fallacy of your own position.

	There's no fallacy in Pablo's position. More correctly, you are
	suffering from a phallusy bacause you can't see the wood for the
	trees.

-am Received on Tue Nov 25 1997 - 00:00:00 CET