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