php-db | 2002122

RE: [PHP-DB] postgresql vs mysql From: John W. Holmes (holmes072000 <email protected>)
Date: 12/27/02

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 <email protected>]
> Sent: Friday, December 27, 2002 3:58 PM
> To: David Bryant; Ryan Jameson (USA); php-db <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:dbryant <email protected>]
> Sent: Thursday, December 26, 2002 10:43 PM
> To: 'Ryan Jameson (USA)'; php-db <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:RJameson <email protected>]
> Sent: Thursday, December 26, 2002 1:18 PM
> To: php-db <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:es18 <email protected>]
> Sent: Thursday, December 26, 2002 12:58 PM
> To: php-db <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