Skip to content

Instantly share code, notes, and snippets.

@dw
Created February 6, 2015 23:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dw/1289d4ea4fd96ad8513e to your computer and use it in GitHub Desktop.
Save dw/1289d4ea4fd96ad8513e to your computer and use it in GitHub Desktop.
[23:19:21 k3!2 py-lmdb] ~/pypy-2.4.0/bin/pypy examples/dirtybench.py
permutate 1876098 words avglen 13 took 2.74sec
DB_PATH: /ram/testdb
insert: 3.070s 611142/sec
stat: {'branch_pages': 244L, 'entries': 1876098L, 'overflow_pages': 0L, 'psize': 4096, 'depth': 4, 'leaf_pages': 25385L}
k+v size 50911.31kb avg 27, on-disk size: 101540.00kb avg 55
enum (key, value) pairs: 0.544s 3447601/sec
reverse enum (key, value) pairs: 0.495s 3790924/sec
enum (key, value) buffers: 0.483s 3883482/sec
rand lookup: 2.825s 664046/sec
per txn rand lookup: 9.643s 194565/sec
rand lookup+hash: 2.885s 650203/sec
rand lookup buffers: 2.768s 677809/sec
rand lookup+hash buffers: 3.023s 620600/sec
rand lookup buffers (cursor): 3.120s 601345/sec
get+put: 4.406s 425799/sec
replace: 9.173s 204514/sec
get+put (cursor): 3.881s 483442/sec
replace (cursor): 4.273s 439047/sec
insert (rand): 3.087s 607734/sec
insert (seq): 1.648s 1138612/sec
insert (rand), reuse cursor: 3.358s 558733/sec
insert (seq), reuse cursor: 0.830s 2261004/sec
insert, putmulti: 3.277s 572498/sec
insert, putmulti+generator: 3.299s 568608/sec
append: 0.751s 2497947/sec
append, reuse cursor: 0.716s 2619809/sec
append+putmulti: 0.609s 3082949/sec
stat: {'branch_pages': 117L, 'entries': 1876098L, 'overflow_pages': 0L, 'psize': 4096, 'depth': 3, 'leaf_pages': 17460L}
k+v size 50911.31kb avg 27, on-disk size: 69840.00kb avg 38
[23:18:13 k3!28 py-lmdb] ~/pypy/bin/pypy examples/dirtybench.py
permutate 1876098 words avglen 13 took 1.82sec
DB_PATH: /ram/testdb
insert: 2.243s 836404/sec
stat: {'psize': 4096, 'depth': 4, 'branch_pages': 282L, 'leaf_pages': 26980L, 'overflow_pages': 0L, 'entries': 1876098L}
k+v size 50911.31kb avg 27, on-disk size: 107920.00kb avg 58
enum (key, value) pairs: 0.482s 3895453/sec
reverse enum (key, value) pairs: 0.452s 4152892/sec
enum (key, value) buffers: 0.418s 4492606/sec
rand lookup: 1.990s 942689/sec
per txn rand lookup: 5.848s 320811/sec
rand lookup+hash: 2.107s 890550/sec
rand lookup buffers: 1.952s 961025/sec
rand lookup+hash buffers: 2.206s 850501/sec
rand lookup buffers (cursor): 1.780s 1053692/sec
get+put: 3.632s 516519/sec
replace: 6.795s 276112/sec
get+put (cursor): 2.576s 728261/sec
replace (cursor): 2.579s 727567/sec
insert (rand): 2.244s 835945/sec
insert (seq): 1.721s 1089922/sec
insert (rand), reuse cursor: 2.101s 893012/sec
insert (seq), reuse cursor: 0.912s 2057871/sec
insert, putmulti: 1.968s 953345/sec
insert, putmulti+generator: 2.059s 911293/sec
append: 0.816s 2298190/sec
append, reuse cursor: 0.791s 2370597/sec
append+putmulti: 0.663s 2830141/sec
stat: {'psize': 4096, 'depth': 3, 'branch_pages': 117L, 'leaf_pages': 17460L, 'overflow_pages': 0L, 'entries': 1876098L}
k+v size 50911.31kb avg 27, on-disk size: 69840.00kb avg 38
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment