any formal benchmarking of Open source Database software?

Question

Is there any formal performance and stress test reports of open source database, specially sqlite,MySQL an PgSQL?

I want to use sqlite in server for its simple structure and easy embeddable capability. But I can not find any pros and cons (by Googling and Yahoo!ing) regarding performance of these database software.

Please suggest.

Answer 1

I found this article. It has a disclaimer at the top about the age of the information. However, it may be some help to you.

Here is another article that seems a little more recent and up2date.

Seems from reading these that SQLite is quite adequate in terms of performance.

Answer 2

Sysbench is a great utility for benchmarking mysql and I believe has plugins or the capability to test PostgreSQL. Keep in mind that you're not going to get a simple number that says "DBMS A is faster than DBMS B" -- at best you can hope to get an idea of what kind of scaling you'll get for a particular type of workload that is hopefully similar to whatever workload you'll end up throwing at your system.

Regardless of performance, if you really know what you are doing with RDBMS software and need an open source solution, you'll probably want to go with PostgreSQL -- otherwise, stick with MySQL.