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