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

In article <yuten43d90u.fsf_at_mew.corp.sgi.com>, Pablo Sanchez <pablo_at_sgi.com> writes
>>>>>> "Greg" == Greg <greg_at_cyberramp.net> writes:
>Greg>
>Greg>
>Greg> Same reason practically noone writes assembler anymore. Works great if
>Greg> you futz with it enough. No one can afford to futz with it enough
>Greg> though. It's just not economic to do so. Unfortunately for Sybase,
>Greg> they're learning this the hard way.
>Greg>
>
>... let's make it easy... why is Sybase's TPC-C's higher
>than Informix? They're both OLTP? As I said, row-level vs
>page-level is hype.

  page level locks give HIGHER PERFORMANCE yes BItUT the reduce   concurrency and hence LOWER RELIABILITY. It's a tradeoff and   most of the time people go for reliability over a little more   performance. 90% of performance tuning is

1. reducing disk I/O by only selecting/updating the minimum amount of data.
2. database schema / index usage.

  anyway.

-- 
David Williams