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

In article <347AA2DF.421D_at_agd.nsw.gov.au>, Anthony Mandic <no_sp.am_at_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_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!