Result table: plain / 31884049900
← plain home |
dcompact →
generated (UTC): 2026-08-15 14:01:09+00:00
raw logs: ToplingDB zipkeyonly | ToplingDB zipkeyvalue | RocksDB v8.10 | RocksDB master (323d915d) | DB INFO LOGs + bench yamls (Actions artifact)
ToplingDB bench yaml: zipkeyonly db_bench-fillrandom.yaml | zipkeyonly db_bench-fillseq.yaml | zipkeyvalue db_bench-fillrandom.yaml | zipkeyvalue db_bench-fillseq.yaml
Runner hardware/software
| OS | Ubuntu 24.04.4 LTS |
| Kernel | 6.17.0-1022-azure |
| CPU | AMD EPYC 7763 64-Core Processor |
| Logical CPUs | 4 |
| Memory | 15.6GiB |
| /dev/shm | 7.8GiB |
| RocksDB block cache | 7.8GiB |
num=50000000 | key_size=8 | value_size=50
On-disk DB size (1.9GiB) ≤ block cache (7.8GiB) — cache can hold the entire dataset. So this benchmark mainly shows CPU and memory cost. With ToplingDB dcompact, most of that CPU and memory cost can be offloaded.
ToplingDB zipkeyonly
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 0.808897 | 1236238 | 40.445 | 50000000 | 68.4 MB/s |
| compact | 32276179.000000 | 0 | 32.276 | 1 | |
| readseq | 0.040957 | 24415147 | 2.048 | 50000000 | 1350.5 MB/s |
| readseq | 0.041036 | 24368098 | 2.052 | 50000000 | 1347.9 MB/s |
| readseq | 0.041189 | 24277925 | 2.059 | 50000000 | 1342.9 MB/s |
| readrandom | 0.168250 | 5943500 | 8.413 | 50000000 | 207.8 MB/s (31608871 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.419214 | 2385411 | 20.961 | 50000000 | 131.9 MB/s |
| compact | 21066301.000000 | 0 | 21.066 | 1 | |
| readseq | 0.032591 | 30682037 | 1.630 | 50000000 | 1697.1 MB/s |
| readseq | 0.032580 | 30692490 | 1.629 | 50000000 | 1697.7 MB/s |
| readseq | 0.032575 | 30697615 | 1.629 | 50000000 | 1698.0 MB/s |
| readrandom | 0.144327 | 6928636 | 7.216 | 50000000 | 383.2 MB/s (50000000 of 50000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.025127 | 39796084 | 1.256 | 50000000 | 303.6 MB/s |
| nextwithkey | 0.025228 | 39637145 | 1.261 | 50000000 | 302.4 MB/s |
| nextwithkey | 0.025205 | 39672275 | 1.260 | 50000000 | 302.7 MB/s |
| readseq | 0.025641 | 38999765 | 1.282 | 50000000 | 297.5 MB/s |
| readseq | 0.025636 | 39006154 | 1.282 | 50000000 | 297.6 MB/s |
| readseq | 0.025812 | 38739449 | 1.291 | 50000000 | 295.6 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019172 | 52155155 | 0.959 | 50000000 | 397.9 MB/s |
| nextwithkey | 0.019089 | 52383391 | 0.955 | 50000000 | 399.7 MB/s |
| nextwithkey | 0.019001 | 52625430 | 0.950 | 50000000 | 401.5 MB/s |
| readseq | 0.019468 | 51362334 | 0.973 | 50000000 | 391.9 MB/s |
| readseq | 0.019451 | 51409282 | 0.973 | 50000000 | 392.2 MB/s |
| readseq | 0.019469 | 51360751 | 0.974 | 50000000 | 391.9 MB/s |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 249488561 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 6.49828 MiB/s |
| fillrandom | write us/op | 2.49489 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 301664950 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 5.37433 MiB/s |
| readrandom | read us/op | 3.01665 |
memtablerep_bench (cspp, ToplingDB only)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 32213261 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 50.3285 MiB/s |
| fillrandom | write us/op | 0.322133 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 40695763 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 39.8382 MiB/s |
| readrandom | read us/op | 0.406958 |
ToplingDB zipkeyvalue
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 0.811291 | 1232597 | 40.565 | 50000000 | 68.2 MB/s |
| compact | 40499398.000000 | 0 | 40.499 | 1 | |
| readseq | 0.059692 | 16752528 | 2.985 | 50000000 | 926.6 MB/s |
| readseq | 0.059308 | 16861103 | 2.965 | 50000000 | 932.6 MB/s |
| readseq | 0.059889 | 16697133 | 2.995 | 50000000 | 923.6 MB/s |
| readrandom | 0.443231 | 2256155 | 22.162 | 50000000 | 78.9 MB/s (31608347 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.419881 | 2381622 | 20.994 | 50000000 | 131.7 MB/s |
| compact | 63754543.000000 | 0 | 63.755 | 1 | |
| readseq | 0.047988 | 20838204 | 2.399 | 50000000 | 1152.6 MB/s |
| readseq | 0.047410 | 21092124 | 2.371 | 50000000 | 1166.7 MB/s |
| readseq | 0.047309 | 21136974 | 2.366 | 50000000 | 1169.2 MB/s |
| readrandom | 0.596880 | 1675373 | 29.844 | 50000000 | 92.7 MB/s (50000000 of 50000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.025241 | 39617328 | 1.262 | 50000000 | 302.3 MB/s |
| nextwithkey | 0.025258 | 39588846 | 1.263 | 50000000 | 302.0 MB/s |
| nextwithkey | 0.024918 | 40130439 | 1.246 | 50000000 | 306.2 MB/s |
| readseq | 0.025604 | 39055268 | 1.280 | 50000000 | 298.0 MB/s |
| readseq | 0.025820 | 38727957 | 1.291 | 50000000 | 295.5 MB/s |
| readseq | 0.025660 | 38969278 | 1.283 | 50000000 | 297.3 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019070 | 52435800 | 0.954 | 50000000 | 400.1 MB/s |
| nextwithkey | 0.019258 | 51923560 | 0.963 | 50000000 | 396.1 MB/s |
| nextwithkey | 0.019168 | 52167507 | 0.958 | 50000000 | 398.0 MB/s |
| readseq | 0.019449 | 51412877 | 0.973 | 50000000 | 392.2 MB/s |
| readseq | 0.019502 | 51274741 | 0.975 | 50000000 | 391.2 MB/s |
| readseq | 0.019456 | 51395067 | 0.973 | 50000000 | 392.1 MB/s |
RocksDB v8.10
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.296 | 771359 | 64.821 | 50000000 | 42.7 MB/s |
| compact | 27495496.000 | 0 | 27.496 | 1 | |
| readseq | 0.132 | 7598914 | 4.159 | 31603681 | 420.3 MB/s |
| readseq | 0.094 | 10676284 | 2.960 | 31603681 | 590.5 MB/s |
| readseq | 0.093 | 10700934 | 2.953 | 31603681 | 591.9 MB/s |
| readrandom | 2.514 | 397734 | 125.712 | 50000000 | 13.9 MB/s (31602173 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.264 | 3787429 | 13.202 | 50000000 | 209.5 MB/s |
| compact | 18968290.000 | 0 | 18.968 | 1 | |
| readseq | 0.153 | 6550568 | 7.633 | 50000000 | 362.3 MB/s |
| readseq | 0.094 | 10693425 | 4.676 | 50000000 | 591.5 MB/s |
| readseq | 0.094 | 10689409 | 4.678 | 50000000 | 591.3 MB/s |
| readrandom | 2.782 | 359406 | 139.118 | 50000000 | 19.9 MB/s (50000000 of 50000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 254939577 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 6.35934 MiB/s |
| fillrandom | write us/op | 2.5494 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 315857415 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 5.13284 MiB/s |
| readrandom | read us/op | 3.15857 |
RocksDB master (323d915d)
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.447 | 691173 | 72.341 | 50000000 | 38.2 MB/s |
| compact | 24695486.000 | 0 | 24.696 | 1 | |
| readseq | 0.179 | 5579324 | 5.665 | 31605254 | 308.6 MB/s |
| readseq | 0.131 | 7652833 | 4.130 | 31605254 | 423.3 MB/s |
| readseq | 0.131 | 7657977 | 4.127 | 31605254 | 423.6 MB/s |
| readrandom | 2.637 | 379235 | 131.844 | 50000000 | 13.3 MB/s (31611597 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.262 | 3812795 | 13.114 | 50000000 | 210.9 MB/s |
| compact | 19570207.000 | 0 | 19.570 | 1 | |
| readseq | 0.197 | 5078738 | 9.845 | 50000000 | 280.9 MB/s |
| readseq | 0.132 | 7584616 | 6.592 | 50000000 | 419.5 MB/s |
| readseq | 0.130 | 7702374 | 6.492 | 50000000 | 426.0 MB/s |
| readrandom | 2.785 | 359096 | 139.238 | 50000000 | 19.9 MB/s (50000000 of 50000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 264941346 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 6.11927 MiB/s |
| fillrandom | write us/op | 2.64941 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 320677747 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 5.05569 MiB/s |
| readrandom | read us/op | 3.20678 |