With integer->blob mapping patch I get these results:
$ ./db_bench_sqlite3 SQLite: version 3.7.7.1 Date: Fri Jul 29 05:32:05 2011 CPU: 2 * Intel(R) Atom(TM) CPU N450 @ 1.66GHz CPUCache: 512 KB Keys: 16 bytes each Values: 100 bytes each Entries: 1000000 RawSize: 110.6 MB (estimated) ------------------------------------------------ fillseq : 77.394 micros/op; 1.3 MB/s fillseqsync : 133.326 micros/op; 0.7 MB/s (10000 ops) fillseqbatch : 31.511 micros/op; 3.1 MB/s fillrandom : 518.605 micros/op; 0.2 MB/s fillrandsync : 227.374 micros/op; 0.4 MB/s (10000 ops) fillrandbatch : 411.859 micros/op; 0.2 MB/s overwrite : 793.869 micros/op; 0.1 MB/s overwritebatch : 743.661 micros/op; 0.1 MB/s readrandom : 31.236 micros/op; readseq : 20.331 micros/op; fillrand100K : 4872.027 micros/op; 19.6 MB/s (1000 ops) fillseq100K : 7249.182 micros/op; 13.2 MB/s (1000 ops) readseq100K : 634.887 micros/op; readrand100K : 606.026 micros/op; $ ./db_bench LevelDB: version 1.2 Date: Fri Jul 29 11:20:59 2011 CPU: 2 * Intel(R) Atom(TM) CPU N450 @ 1.66GHz CPUCache: 512 KB Keys: 16 bytes each Values: 100 bytes each (50 bytes after compression) Entries: 1000000 RawSize: 110.6 MB (estimated) FileSize: 62.9 MB (estimated) WARNING: Snappy compression is not enabled ------------------------------------------------ fillseq : 10.107 micros/op; 10.9 MB/s fillsync : 276.920 micros/op; 0.4 MB/s (1000 ops) fillrandom : 21.275 micros/op; 5.2 MB/s overwrite : 30.717 micros/op; 3.6 MB/s readrandom : 48.781 micros/op; readrandom : 39.841 micros/op; readseq : 2.227 micros/op; 49.7 MB/s readreverse : 3.549 micros/op; 31.2 MB/s compact : 5274551.868 micros/op; readrandom : 35.392 micros/op; readseq : 1.743 micros/op; 63.5 MB/s readreverse : 2.927 micros/op; 37.8 MB/s fill100K : 6631.138 micros/op; 14.4 MB/s (1000 ops) crc32c : 11.447 micros/op; 341.2 MB/s (4K per op) snappycomp : 8.106 micros/op; (snappy failure) snappyuncomp : 26.941 micros/op; (snappy failure) acquireload : 1.407 micros/op; (each op is 1000 loads) -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users