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