RE: [PHP-DB] postgresql vs mysql
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
RE: [PHP-DB] postgresql vs mysql
This is why i was amazed to see this : http://www.mysql.com/eweek/index.html -Original Message- From: David Bryant [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:43 PM To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is changing however. PG has made some significant improvements in speed this last year, but MySQL is improving performance considerably with larger and more complex RDBs.) PG has a much flatter performance line regardless of db size, whereas MySQL just gets much slower and slower as the db MB increases. -D AdPak Communications, Inc. Network Security Products, Sales Support (623) 936-4800 * Toll Free 1-888-600-7066 * Fax: (623) 936-4111 Who Is Watching Your Network? Corporate/Sales/Service: www.adpak.com -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql There's a substantiated rumor that says postgres is faster for complex queries. Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for which the lead programmer wants to use postgresql. I'll be working in php. Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] postgresql vs mysql
I wish they had included PG on that list of databases. That would have been good to see regardless of the results. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -Original Message- From: Boaz Yahav [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 3:58 PM To: David Bryant; Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql This is why i was amazed to see this : http://www.mysql.com/eweek/index.html -Original Message- From: David Bryant [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:43 PM To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is changing however. PG has made some significant improvements in speed this last year, but MySQL is improving performance considerably with larger and more complex RDBs.) PG has a much flatter performance line regardless of db size, whereas MySQL just gets much slower and slower as the db MB increases. -D AdPak Communications, Inc. Network Security Products, Sales Support (623) 936-4800 * Toll Free 1-888-600-7066 * Fax: (623) 936-4111 Who Is Watching Your Network? Corporate/Sales/Service: www.adpak.com -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql There's a substantiated rumor that says postgres is faster for complex queries. Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for which the lead programmer wants to use postgresql. I'll be working in php. Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- 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 -- 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
Re: [PHP-DB] postgresql vs mysql
This benchmark do not help much in real life, if one care database performance. Database performance will vary a lot with configuration/schema/query/etc. It's very easy to make one is better while another is not. 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) BTW, SourceForge.net is using PostgreSQL. It's one of the biggest web site using PostgreSQL that I know of. (I mean SourceForge.net system itself, not database service available from sf.net. MySQL was more suitable for sharing database server with many users until PostgreSQL 7.3) -- Yasuo Ohgaki Boaz Yahav wrote: This is why i was amazed to see this : http://www.mysql.com/eweek/index.html -Original Message- From: David Bryant [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:43 PM To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is changing however. PG has made some significant improvements in speed this last year, but MySQL is improving performance considerably with larger and more complex RDBs.) PG has a much flatter performance line regardless of db size, whereas MySQL just gets much slower and slower as the db MB increases. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] postgresql vs mysql
i emailed the author (dyck timothy) of this article (server database clash) by eweek he told me that they benchmark DB's according to market share that is why they didnt included PG (not widely used). - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: 'Boaz Yahav' [EMAIL PROTECTED]; 'David Bryant' [EMAIL PROTECTED]; 'Ryan Jameson (USA)' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 5:12 AM Subject: RE: [PHP-DB] postgresql vs mysql I wish they had included PG on that list of databases. That would have been good to see regardless of the results. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -Original Message- From: Boaz Yahav [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 3:58 PM To: David Bryant; Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql This is why i was amazed to see this : http://www.mysql.com/eweek/index.html -Original Message- From: David Bryant [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:43 PM To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is changing however. PG has made some significant improvements in speed this last year, but MySQL is improving performance considerably with larger and more complex RDBs.) PG has a much flatter performance line regardless of db size, whereas MySQL just gets much slower and slower as the db MB increases. -D AdPak Communications, Inc. Network Security Products, Sales Support (623) 936-4800 * Toll Free 1-888-600-7066 * Fax: (623) 936-4111 Who Is Watching Your Network? Corporate/Sales/Service: www.adpak.com -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql There's a substantiated rumor that says postgres is faster for complex queries. Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for which the lead programmer wants to use postgresql. I'll be working in php. Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- 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 -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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
Re: [PHP-DB] postgresql vs mysql
John W. Holmes wrote: 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. Real life differs from systems to systems :) It is useful to see how dbms performs, but performance of dbms heavily depends of how users use them. (Isn't MySQL have severe performance penalty with complex query like sub query?) Yes, perhaps you can loan me the money to get Oracle and MSSQL licenses so I can test them out? I thought original poster would like to compare PostgreSQL and MySQL. What's this got to do with PHP? Nada... Happy New Year! Compare performance PostgreSQL and MySQL using PHP? Have a happy new year. -- Yasuo Ohgaki -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] postgresql vs mysql
There's a substantiated rumor that says postgres is faster for complex queries. Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for which the lead programmer wants to use postgresql. I'll be working in php. Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- 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
RE: [PHP-DB] postgresql vs mysql
I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is changing however. PG has made some significant improvements in speed this last year, but MySQL is improving performance considerably with larger and more complex RDBs.) PG has a much flatter performance line regardless of db size, whereas MySQL just gets much slower and slower as the db MB increases. -D AdPak Communications, Inc. Network Security Products, Sales Support (623) 936-4800 * Toll Free 1-888-600-7066 * Fax: (623) 936-4111 Who Is Watching Your Network? Corporate/Sales/Service: www.adpak.com -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql There's a substantiated rumor that says postgres is faster for complex queries. Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for which the lead programmer wants to use postgresql. I'll be working in php. Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php