Re: 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" <holmes072000@charter.net> To: "'Boaz Yahav'" <berber@netvision.net.il>; "'David Bryant'" <dbryant@adpak.com>; "'Ryan Jameson (USA)'" <RJameson@usa.ibs.org>; <php-db@lists.php.net> 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:berber@netvision.net.il] > Sent: Friday, December 27, 2002 3:58 PM > To: David Bryant; Ryan Jameson (USA); php-db@lists.php.net > 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:dbryant@adpak.com] > Sent: Thursday, December 26, 2002 10:43 PM > To: 'Ryan Jameson (USA)'; php-db@lists.php.net > 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:RJameson@usa.ibs.org] > Sent: Thursday, December 26, 2002 1:18 PM > To: php-db@lists.php.net > 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:es18@hotmail.com] > Sent: Thursday, December 26, 2002 12:58 PM > To: php-db@lists.php.net > 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