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

In article <yuten43d90u.fsf@mew.corp.sgi.com>, Pablo Sanchez <pablo@sgi.com> writes >>>>>> "Greg" == Greg <greg@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 a) reducing disk I/O by only selecting/updating the minimum amount of data. b) database schema / index usage. anyway. -- David Williams