SQLite vs SQLightning

Running on Ubuntu 12.04LTS with 3.10.11-031011-generic kernel. Crucial M4 512GB SSD with reiserfs.

Note that this version of SQLite now supports mmap'd I/O, but I haven't yet tweaked the benchmark code to use it. Will have to try that out soon too.

Vanilla SQLite3
SQLite:     version 3.7.17
Date:       Sat Sep 14 20:54:14 2013
CPU:        4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
CPUCache:   6144 KB
Keys:       16 bytes each
Values:     100 bytes each
Entries:    1000000
RawSize:    110.6 MB (estimated)
------------------------------------------------
fillseqsync  :    8175.371 micros/op;    0.0 MB/s
168	/home/software/leveldb/test/dbbench_sqlite3-1.db
8761	/home/software/leveldb/test/dbbench_sqlite3-1.db-wal
fillrandsync :    8308.706 micros/op;    0.0 MB/s
164	/home/software/leveldb/test/dbbench_sqlite3-2.db
8861	/home/software/leveldb/test/dbbench_sqlite3-2.db-wal
fillseq      :      25.587 micros/op;    4.3 MB/s
153450	/home/software/leveldb/test/dbbench_sqlite3-3.db
16524	/home/software/leveldb/test/dbbench_sqlite3-3.db-wal
fillseqbatch :       7.402 micros/op;   14.9 MB/s
153462	/home/software/leveldb/test/dbbench_sqlite3-4.db
16644	/home/software/leveldb/test/dbbench_sqlite3-4.db-wal
fillrandom   :      33.235 micros/op;    3.3 MB/s
152561	/home/software/leveldb/test/dbbench_sqlite3-5.db
16524	/home/software/leveldb/test/dbbench_sqlite3-5.db-wal
fillrandbatch :      18.847 micros/op;    5.9 MB/s
152625	/home/software/leveldb/test/dbbench_sqlite3-6.db
20692	/home/software/leveldb/test/dbbench_sqlite3-6.db-wal
readrandom   :      22.645 micros/op;
readseq      :       7.557 micros/op;   12.6 MB/s
readreverse  :       7.456 micros/op;   12.8 MB/s


SQLightning:
SQLite:     version 3.7.17
Date:       Sat Sep 14 20:49:14 2013
CPU:        4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
CPUCache:   6144 KB
Keys:       16 bytes each
Values:     100 bytes each
Entries:    1000000
RawSize:    110.6 MB (estimated)
------------------------------------------------
fillseqsync  :    6171.233 micros/op;    0.0 MB/s
420	/home/software/leveldb/test/dbbench_sqlite3-1.db
0	/home/software/leveldb/test/dbbench_sqlite3-1.db-lock
fillrandsync :    6231.249 micros/op;    0.0 MB/s
408	/home/software/leveldb/test/dbbench_sqlite3-2.db
0	/home/software/leveldb/test/dbbench_sqlite3-2.db-lock
fillseq      :      31.778 micros/op;    3.5 MB/s
353077	/home/software/leveldb/test/dbbench_sqlite3-3.db
0	/home/software/leveldb/test/dbbench_sqlite3-3.db-lock
fillseqbatch :       7.087 micros/op;   15.6 MB/s
353077	/home/software/leveldb/test/dbbench_sqlite3-4.db
0	/home/software/leveldb/test/dbbench_sqlite3-4.db-lock
fillrandom   :      32.902 micros/op;    3.4 MB/s
334610	/home/software/leveldb/test/dbbench_sqlite3-5.db
4	/home/software/leveldb/test/dbbench_sqlite3-5.db-lock
fillrandbatch :      13.754 micros/op;    8.0 MB/s
343303	/home/software/leveldb/test/dbbench_sqlite3-6.db
0	/home/software/leveldb/test/dbbench_sqlite3-6.db-lock
readrandom   :       7.685 micros/op;
readseq      :       1.551 micros/op;   61.5 MB/s
readreverse  :       1.531 micros/op;   62.3 MB/s

http://symas.com/mdb
https://gitorious.org/mdb/sqlightning