Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Date: 1997/11/26
Message-ID: <yut67pfc6qb.fsf_at_mew.corp.sgi.com>#1/1
>>>>> "David" == David Williams <djw_at_smooth1.demon.co.uk> writes:
How do you assert "reduced concurrency" when the unit of
measure is tpmC: transactions per minute of type C's?
I believe your assertion is wrong.
agreed
David>
David> page level locks give HIGHER PERFORMANCE yes BItUT the reduce
David> concurrency and hence LOWER RELIABILITY.
Informix... 24,000 transactions per minute of type C
Sybase..... 34,000 transactions per minute of type C
David> most of the time people go for reliability over a little more
David> performance. 90% of performance tuning is
David>
David> a) reducing disk I/O by only selecting/updating the minimum
David> amount of data.
David> b) database schema / index usage.
agreed
c) proper hardware for both the client and the server d) configuring the server properly: - log on its own device (sequential writes in nature) - data on its own set of devices due to its mostly random access nature for OLTP e) proper network bandwidth and proper use of packages f) ... -- 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 ] Received on Wed Nov 26 1997 - 00:00:00 CET