Re: Is MS-SQL6.5 in the same league as Oracle, Sybase?

Oracles locking is better - than what?

Basically it comes down to designing for the database you are using - dont believe anyone who says you can treat databases transparently.

For a given amount (within a factor of 10) of tuning effort, Sybase will walk over Oracle for performance.

Pre System 11 I converted an Oracle system to Sybase and spent an hour tuning the system. An Oracle consultant had spent 3 dys tuning his version.

Sybase supported 5 times the workload of Oracle - and thats before XI came along.

QED.
>
>
> > > Sybase XI is the undisputed king of performance from the Alpha to the
 PC!
> > > Oracle may do a damn good job in marketing, but we have better products.
> > >
> > > Lately I have not seen any performance measurements in Oracle that even
> > > come close to the performance of System XI on the same hardware. System
> > > XI on SCO posted the highest PC numbers. Heck Sybase System XI NT even
> > > out performed SQL SERVER 6.5 on NT -- On their own OS!
> > >
> > > Check out the published results: http://www.sybase.com/products/tpc
> > >
> > > Here is a sample:
> > >
> > > Database TPM-C $/TPM-C Hardware
> > > ===============================================================
> > > Sybase: 14176.25 198 Alpha Server 8400 5/350
> > > Informix: 13646.17 277 Alpha Server 8400 5/350
> > > Oracle: 11456.13 286 Alpha Server 8400 5/350 (Not
 even close)
> > > Microsoft: Nothing close in front, mid, or back office :-)
> > >
> > > Comparisons on identical hardware.
>
> All true but Oracles locking is better...
>
> Steve.devos

Peter Collard			Please note that I am a contractor
Senior DBA			so these are my own views and
Lehman Bros			may not coincide with those of
London				Lehman Bros.
==================================================================