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

Pablo Sanchez wrote:

> 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.
>

No, you don't have your seat until you get a confirmation number.Its that simple. (Confirmation numbers occur after the transaction is completed. Its obvious you haven't written a hotel reservation system.

My whole point is that this thread is a waste of breathe. Conceputaly the finer the granularity of locks acheived, the better the application will
behave and the easier it is to implement an OLTP application.

Now, as to TPC benchmarks, why don't you print the configurations used. :-) (Yes Virginia, I have done benchmarking and I know that everyone cheats:-)

> 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?
>

He's saying that there are other things that Sybase does well, inspite of not havingrow level locking. Would you care to elaborate. It was the same point I was trying to
make. Only you thought to say SNIP! :-)

> 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...
>

No, this whole thread is a stray. That's the point I was trying to make since itssilly to say that page level locking is better than row level locking.

> 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.
>

Uhmm, well no. Scale your application up. Increase the number of users.Then lets talk about performance. Please understand that IMHO, the best place to tune a system is at the app level, not the db engine. Of course, a well tuned engine is important.

> 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.

Well, how many retail customers use Sybase? Reservation Systems?(SABRE is still mainframe AFAIK)

That's the real test.

> --
> 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 ]

  -Mikey Received on Mon Dec 01 1997 - 00:00:00 CET