[GNUnet-developers] Performance comparasion between sqlite and mysql

[Mikael Karlsson]

sqlite
Upload of `/tmp/ubuntu-5.04-install-i386.iso' complete, 615307264 bytes
took 424 seconds (1414.692 kbps).

mysql
Upload of `/tmp/ubuntu-5.04-install-i386.iso' complete, 615307264 bytes
took 350 seconds (1714.637 kbps).

/dev/sda:
 Timing cached reads:   2792 MB in  2.00 seconds = 1395.52 MB/sec
 Timing buffered disk reads:  162 MB in  3.02 seconds =  53.67 MB/sec

1.6 GHz amd64

gcc version 3.3.5 (Debian 1:3.3.5-8ubuntu2)

The slower sqlite performance could possibly be attributed to us doing
single inserts instead of a larger transaction. The iowait was alot
higher for sqlite.

/Mikael Karlsson