[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
>>>>> "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