[PLUG] Re: ISP's and db's

[Kevin Falcone <kevin@jibsheet.com>]

>>>>> "JA" == Jeff Abrahamson <jeff@purple.com> writes:

  JA> Can any of our ISP folks shed some light on why ISP's generally
  JA> prefer to run MySQL instead of PostgreSQL?

Speed.  For a long time it kicked the hell out of Postgres in
benchmarks, and if all you are doing is a lot of selects out of medium
to largish sized tables with the occasional insert/update, then MySQL
works quite well.

Also, documentation/tutorials for PHP and perl's DBI often only use
the MySQL interface, neglecting postgres (although DBI docs do mention
Oracle a lot, mainly because of Tim Bunce)

I currently use MySQL on a production server with a few tables
averaging from 20000-100000 rows and it works quite well.  The only
thing I miss sometimes are subselects.

Oh, and probably the number on reason ISPs use MySQL?  It is what
people request because they don't know anything else.

-kevin

-- 
Bartender, gimme one of whatever the guy on the floor was having.



______________________________________________________________________
Philadelphia Linux Users Group       -      http://www.phillylinux.org
Announcements-http://lists.phillylinux.org/mail/listinfo/plug-announce
General Discussion  -  http://lists.phillylinux.org/mail/listinfo/plug