Topic: MySQL, PostgreSQL, SQLite, pros and cons ?
want to know your opinion about performance, reliability, convinience etc.,
applying to web hosting. especially about performance under (heavy)loads
Re: MySQL, PostgreSQL, SQLite, pros and cons ?
SQLite is out of the question. It's very fast when there is no load, but since it locks the whole database (it's only one file) during updates and inserts, it does not perform very well under load.
I vote for MySQL. It's extermely fast (especially 4.*) and it has very strong industry support. PostgreSQL has lots and lots of features. It's the most full-featured open source database, but when it comes to performance, it has nothing on MySQL. To top things off, MySQL is Swedish :)
"Programming is like sex: one mistake and you have to support it for the rest of your life."
- Connorhd
- Former PunBB Developer
- Offline
Re: MySQL, PostgreSQL, SQLite, pros and cons ?
Sweden is taking over the world.
Re: MySQL, PostgreSQL, SQLite, pros and cons ?
We sure are! 