Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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 rifling through the Monastery: (5)
As of 2016-02-13 14:01 GMT
Find Nodes?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?

    Results (436 votes), past polls