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

>>>>> "David" == David Williams <djw@smooth1.demon.co.uk> writes: David> David> page level locks give HIGHER PERFORMANCE yes BItUT the reduce David> concurrency and hence LOWER RELIABILITY. How do you assert "reduced concurrency" when the unit of measure is tpmC: transactions per minute of type C's? Informix... 24,000 transactions per minute of type C Sybase..... 34,000 transactions per minute of type C I believe your assertion is wrong. 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. agreed 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@sgi.com | Pg # (800) 930.5635 -or- pablo_p@pager.sgi.com ------------------------------------------------------------------------------- I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]