Home  /  RSS  /  RSS Comments  /  Enter

The Cost of SQL - First Measurements

Wednesday, February 27, 2008, by artyom ; Posted in: Storage, Benchmarks, Berkeley DB; 0 comments

There are the preliminary benchmarks comparing different DB backends. I've measured pages per second ratio for fetching different pages from the blog that includes 5,000 articles and 50,000 comments to them. The client and the server had run on the same PC.

The settings and the database is the same that is used in this article.

Backend         gzip no-gzip   gzip   no-gzip %
------------------------------------------------
Berkeley DB     565  830       N/A    N/A
MySQL InnoDB    475  645       -16%   -22%
Sqlite3         410  515       -27%   -38%
PostgreSQL      305  360       -46%   -57%

We can see:

  1. There is not negligible cost of using SQL Data Bases. However the price is not too high with fast data bases like MySQL.
  2. PostgreSQL had badly surprised me with its real performance. Maybe I'm doing something wrong?

Add Comment:

 
 the email would not displayed
 

You can write your messages using Markdown syntax.

You must enable JavaScript in order to post comments.

Pages

Categories