If we want to go to back to the real world, lets check the results at where most of the world does....
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp However if $$$ is an issue, don't bother pressing the link :) Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. -----Original Message----- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 2:48 AM To: 'Yasuo Ohgaki'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql > This benchmark do not help much in real life, if one care database > performance. Did you even read the article? They used a real-world bookstore application called Nile written in JSP and tested it with 50 to 1,000 concurrent users. > Database performance will vary a lot with configuration/schema/query/etc. > It's very easy to make one is better while another is not. Yes, that's why they fine tuned each one. They also invited each company to send representatives to help them tune it. Only MySQL and Sybase did so, IMB offered suggestions over email and apparently Oracle and Microsoft couldn't be bothered. > I suggest to take benchmark by yourself with schema and query that is > similar to production system. (Don't forget to test with large enough > data) Yes, perhaps you can loan me the money to get Oracle and MSSQL licenses so I can test them out? I understand what you're saying, every application is different. Yes, I agree, but for those that can't afford to do extensive benchmarking like this, we have to use these results and assume ours will be the same. What's this got to do with PHP? Nada... Happy New Year! ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
