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

In article <347AA2DF.421D@agd.nsw.gov.au>, Anthony Mandic <no_sp.am@agd.nsw.gov.au> wrote: >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. I agree with the lcd problem, but the changes are not trivial. Can you say Repeatable Read? It's like changing the newsgroup comp.databases.oracle to a hierarchy - the change is trivial, but just try to implement it completely. Coming up on a year, and people still post here. > >> 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 -- These opinions are my own and not necessarily those of Information Quest jgarry@eiq.com http://www.informationquest.com http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA!