http://www.perlmonks.org?node_id=696797


in reply to Re: [OT] Why I don't use Mysql for new projects
in thread [OT] Why I don't use Mysql for new projects

I, as a non MySQL user, would like to hear some answers to another question: why is MySQL better than PostgreSQL? Or, better, are there applications/environments in which MySQL is preferable to PostgreSQL? And why?

I'm by no means an expert either, but this is what I read multiple times:

When you have data this doesn't change very often, and you make many simple queries, MySQL (with MyISAM backend) is blazingly fast.

Replies are listed 'Best First'.
Re^3: [OT] Why I don't use Mysql for new projects
by mr_mischief (Monsignor) on Jul 11, 2008 at 22:09 UTC
    If those are the only advantages, then MySQL is a waste of effort. If you rarely have insertions, deletions, or updates and you have a high volume of simple queries then OpenLDAP will not only have MySQL's lunch but will hand Postgres the empty tray and smack Oracle on the behind as it whistles and dances out of the cafeteria.