Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re^2: [OT] Why I don't use Mysql for new projects

by moritz (Cardinal)
on Jul 10, 2008 at 20:11 UTC ( #696797=note: print w/ replies, xml ) Need Help??

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.

Comment on Re^2: [OT] Why I don't use Mysql for new projects
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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://696797]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2015-11-29 07:44 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (748 votes), past polls