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

>>>>> "Gary" == Gary L Burnore <gburnore> writes:
Gary>
Gary> You DOUBT? Meaning you don't know?

Nope, I don't know SABRE nor "The Other" application well enough to say. If the system crashes when I'm booking a flight, though, I don't lose my seat therefore I believe my assertion is correct.

Gary> Figures.

[ ignored ]

Gary> :
Gary> :Gary> Row level locking is quite important in some
Gary> :Gary> instances.  
Gary> :
Gary> :As I've said, if you look at the TPC-C you can see that for
Gary> :a well behaved application there isn't a problem.  How do
Gary> :you refute that Sybase currently has a higher tpmC value
Gary> :than Informix?  After all, TPC-C's are OLTP and Informix has
Gary> :row level locking.  Answer that for me...
Gary> 
Gary> I'm not refuting it. I'm saying it's not based on
Gary> Sybases lack of row-level locking.

I can't parse the above point. Would you elaborate?

Gary> Look, why not just admit that you like Sybase better Gary> and that's that.

Sybase is fine and so is Informix and as a matter of fact, I like Oracle's architecture too. They all have problems and good points. As a developer it's important to exploit the good points rather than the bad one's. But I stray...

Gary> It's obvious by your posts that's what's true here. Gary> You're not being unbiased about it at _ALL_.

What is obvious is that row level locking doesn't buy you want you *think* it's buying you when you have a finely tuned application. All the examples pointed out to me by folks have been cases of finely tuned apps. See my post to Mike Segal on finely tuned app's.

Facts don't show bias. I'm willing to listen to any facts that you have to support your claims. As of yet, I've seen none.

--
Pablo Sanchez              | Ph # (650) 933.3812          Fax # (650) 933.2821
pablo_at_sgi.com              | Pg # (800) 930.5635   -or-   pablo_p_at_pager.sgi.com
-------------------------------------------------------------------------------
I am accountable for my actions.   http://reality.sgi.com/pablo [ /Sybase_FAQ ]