Home  /  RSS  /  RSS Comments  /  RSS for Benchmarks  /  Enter

Posts in category ‘Benchmarks’.

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?

BDB or not BDB - that is the question...

Monday, February 4, 2008, by artyom ; Posted in: Storage, Benchmarks, Berkeley DB; 12 comments

At the beginning of the project I had several options for president storage for CppCMS:

  1. Use standard SQL databases like MySQL, PostgreSQL.
  2. Use embedded SQL data base like Sqlite3
  3. Use Berkeley DB
  4. Implement my own storage model.

At the beginning I wanted to use MySQL. At certain point I decided to switch to Berkeley DB, and now I come back to the original question: "what data storage to use?"

In order to make a proper design I had run lots of micro benchmarks and finally I had chosen Berkeley DB. However I never used queries from real DB. And now, when I had implemented a simple blog I decided to run benchmarks on the situation that is closer to real one.

I had reimplemented an operation of fetching single post using MySQL and imported the database that included 5000 articles with 10 comments each one and tested.


Benchmarks, First Results

Thursday, December 27, 2007, by artyom ; Posted in: Benchmarks, FastCGI, Framework; 0 comments

Updated 28/12/07, 17:00

In order to show that all the time I had spend on this system wasn't wasted I had run a simple benchmark tests on following setup:



next page

next page