On Fri, Jul 29, 2011 at 12:30 AM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote:
> With integer->blob mapping patch I get these results: > > Good information, Alexey. Thanks for running this. It would seem that the SQLite team has some serious work ahead of us..... > > $ ./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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
