Performance

Below are some statistics collected with the 'Apache HTTP server benchmarking tool' (ab).

Setup is a MacBook Pro (Retina, 15-inch, Late 2013) with 8G RAM and 2.0GHz quad-core Intel Core i7. This machine is both client and server. Server is a UBUNTU precise x64 running in VirtualBox.

To test concurrency and speed, we post an url-encoded Munkireport report file with a size of 68743 Bytes. Below the results for SQLite and MySQL. There are three tests: concurrency 1, 10 and 100.

The test command looks like this:

ab -n 1000 -c 1 -p post.txt -T application/x-www-form-urlencoded http://munkireport.dev/index.php?/report/check_in

SQLite

Concurrency Level:      1
Time taken for tests:   70.382 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      447000 bytes
Total POSTed:           68743000
HTML transferred:       30000 bytes
Requests per second:    14.21 [#/sec] (mean)
Time per request:       70.382 [ms] (mean)
Time per request:       70.382 [ms] (mean, across all concurrent requests)
Transfer rate:          6.20 [Kbytes/sec] received
                        953.82 kb/s sent
                        960.02 kb/s total

Concurrency Level:      10
Time taken for tests:   81.832 seconds
Complete requests:      1000
Failed requests:        1
   (Connect: 0, Receive: 0, Length: 1, Exceptions: 0)
Write errors:           0
Total transferred:      447109 bytes
Total POSTed:           68743000
HTML transferred:       30108 bytes
Requests per second:    12.22 [#/sec] (mean)
Time per request:       818.321 [ms] (mean)
Time per request:       81.832 [ms] (mean, across all concurrent requests)
Transfer rate:          5.34 [Kbytes/sec] received
                        820.36 kb/s sent
                        825.70 kb/s total

Concurrency Level:      100
Time taken for tests:   289.681 seconds
Complete requests:      1000
Failed requests:        15
   (Connect: 0, Receive: 0, Length: 15, Exceptions: 0)
Write errors:           0
Total transferred:      448687 bytes
Total POSTed:           68743000
HTML transferred:       31672 bytes
Requests per second:    3.45 [#/sec] (mean)
Time per request:       28968.065 [ms] (mean)
Time per request:       289.681 [ms] (mean, across all concurrent requests)
Transfer rate:          1.51 [Kbytes/sec] received
                        231.74 kb/s sent
                        233.26 kb/s total

MySQL

Concurrency Level:      1
Time taken for tests:   52.785 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      447000 bytes
Total POSTed:           68743000
HTML transferred:       30000 bytes
Requests per second:    18.94 [#/sec] (mean)
Time per request:       52.785 [ms] (mean)
Time per request:       52.785 [ms] (mean, across all concurrent requests)
Transfer rate:          8.27 [Kbytes/sec] received
                        1271.81 kb/s sent
                        1280.08 kb/s total

Concurrency Level:      10
Time taken for tests:   24.351 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      447000 bytes
Total POSTed:           68743000
HTML transferred:       30000 bytes
Requests per second:    41.07 [#/sec] (mean)
Time per request:       243.510 [ms] (mean)
Time per request:       24.351 [ms] (mean, across all concurrent requests)
Transfer rate:          17.93 [Kbytes/sec] received
                        2756.84 kb/s sent
                        2774.77 kb/s total

Concurrency Level:      100
Time taken for tests:   42.052 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      447000 bytes
Total POSTed:           68743000
HTML transferred:       30000 bytes
Requests per second:    23.78 [#/sec] (mean)
Time per request:       4205.206 [ms] (mean)
Time per request:       42.052 [ms] (mean, across all concurrent requests)
Transfer rate:          10.38 [Kbytes/sec] received
                        1596.40 kb/s sent
                        1606.78 kb/s total