Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Posted in 1997
On 01 Dec 1997 09:56:43 -0700, Pablo Sanchez <pablo@sgi.com> wrote: :>>>>> "Gary" == Gary L Burnore <gburnore> writes: :Gary> :Gary> Tell the airlines that row-level locking isn't :Gary> important. If the entire seating table for a flight :Gary> was locked for one attendent to assign you a seat, :Gary> it'd be caos. : :I doubt very much that SABRE places a logical lock on a :seat. It more than likely updates the row with a "lock :out". You DOUBT? Meaning you don't know? Figures. : :Gary> Row level locking is quite important in some :Gary> instances. : :As I've said, if you look at the TPC-C you can see that for :a well behaved application there isn't a problem. How do :you refute that Sybase currently has a higher tpmC value :than Informix? After all, TPC-C's are OLTP and Informix has :row level locking. Answer that for me... I'm not refuting it. I'm saying it's not based on Sybases lack of row-level locking. : :Gary> I also agree with his statement that to :Gary> defend Sybase by saying that YOU don't think row level :Gary> locking is important is silly. : :That's cool, you can agree that that earth is flat too. How :about just answering the TPC-C question above for me. I can't agree that the world is flat because it's not. Saying such onlys shows you have no argument worth standing with. Look, why not just admit that you like Sybase better and that's that. It's obvious by your posts that's what's true here. You're not being unbiased about it at _ALL_. gburnore@netcom dot com or gburnore@netcom databasix com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | '۳'''''''ۺ''''''''''۳ | '۳'''''''ۺ''''''''''۳ DOH! | '۳'''''''ۺ''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ spamgard(tm): zamboni | Official Proof of Purchase =========================================================================== PGPprint: C63B CF4E 1B71 4D7E C6F8 AF4E 338D 5CB4 KeyID: 0x0F7EDBD9 (RSA) finger gburnore@netcom.com for public key ---------------------------------------------------------------------------