Result table: plain / 31896896755
← plain home |
dcompact →
generated (UTC): 2026-08-15 18:00:11+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 9V74 80-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.867427 | 1152834 | 43.371 | 50000000 | 63.8 MB/s |
| compact | 14997559.000000 | 0 | 14.998 | 1 | |
| readseq | 0.041910 | 23859902 | 2.096 | 50000000 | 1319.8 MB/s |
| readseq | 0.041877 | 23878886 | 2.094 | 50000000 | 1320.8 MB/s |
| readseq | 0.042142 | 23729003 | 2.107 | 50000000 | 1312.5 MB/s |
| readrandom | 0.193486 | 5168312 | 9.674 | 50000000 | 180.7 MB/s (31607670 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.406804 | 2458183 | 20.340 | 50000000 | 136.0 MB/s |
| compact | 19475328.000000 | 0 | 19.475 | 1 | |
| readseq | 0.032817 | 30471175 | 1.641 | 50000000 | 1685.5 MB/s |
| readseq | 0.032861 | 30430339 | 1.643 | 50000000 | 1683.2 MB/s |
| readseq | 0.032888 | 30405690 | 1.644 | 50000000 | 1681.8 MB/s |
| readrandom | 0.147350 | 6786512 | 7.368 | 50000000 | 375.4 MB/s (50000000 of 50000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026282 | 38047436 | 1.314 | 50000000 | 290.3 MB/s |
| nextwithkey | 0.026126 | 38274406 | 1.306 | 50000000 | 292.0 MB/s |
| nextwithkey | 0.026137 | 38258093 | 1.307 | 50000000 | 291.9 MB/s |
| readseq | 0.026926 | 37137252 | 1.346 | 50000000 | 283.3 MB/s |
| readseq | 0.026977 | 37067322 | 1.349 | 50000000 | 282.8 MB/s |
| readseq | 0.026943 | 37114234 | 1.347 | 50000000 | 283.2 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019254 | 51936126 | 0.963 | 50000000 | 396.2 MB/s |
| nextwithkey | 0.019186 | 52118947 | 0.959 | 50000000 | 397.6 MB/s |
| nextwithkey | 0.019194 | 52095706 | 0.960 | 50000000 | 397.5 MB/s |
| readseq | 0.019907 | 50231365 | 0.995 | 50000000 | 383.2 MB/s |
| readseq | 0.020825 | 48015564 | 1.041 | 50000000 | 366.3 MB/s |
| readseq | 0.019921 | 50195057 | 0.996 | 50000000 | 383.0 MB/s |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 343052455 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.72594 MiB/s |
| fillrandom | write us/op | 3.43052 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 444250591 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 3.6494 MiB/s |
| readrandom | read us/op | 4.44251 |
memtablerep_bench (cspp, ToplingDB only)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 39717917 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 40.819 MiB/s |
| fillrandom | write us/op | 0.397179 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 53677645 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 30.2034 MiB/s |
| readrandom | read us/op | 0.536776 |
ToplingDB zipkeyvalue
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 0.848012 | 1179223 | 42.401 | 50000000 | 65.2 MB/s |
| compact | 42374512.000000 | 0 | 42.375 | 1 | |
| readseq | 0.059529 | 16798309 | 2.976 | 50000000 | 929.2 MB/s |
| readseq | 0.059009 | 16946240 | 2.951 | 50000000 | 937.3 MB/s |
| readseq | 0.059075 | 16927256 | 2.954 | 50000000 | 936.3 MB/s |
| readrandom | 0.502433 | 1990310 | 25.122 | 50000000 | 69.6 MB/s (31604995 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.405846 | 2463983 | 20.292 | 50000000 | 136.3 MB/s |
| compact | 62036603.000000 | 0 | 62.037 | 1 | |
| readseq | 0.049791 | 20083523 | 2.490 | 50000000 | 1110.9 MB/s |
| readseq | 0.048533 | 20604188 | 2.427 | 50000000 | 1139.7 MB/s |
| readseq | 0.048441 | 20643226 | 2.422 | 50000000 | 1141.8 MB/s |
| readrandom | 0.664017 | 1505982 | 33.201 | 50000000 | 83.3 MB/s (50000000 of 50000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026179 | 38198001 | 1.309 | 50000000 | 291.4 MB/s |
| nextwithkey | 0.026063 | 38365948 | 1.303 | 50000000 | 292.7 MB/s |
| nextwithkey | 0.025995 | 38466657 | 1.300 | 50000000 | 293.5 MB/s |
| readseq | 0.026913 | 37155052 | 1.346 | 50000000 | 283.5 MB/s |
| readseq | 0.026975 | 37068998 | 1.349 | 50000000 | 282.8 MB/s |
| readseq | 0.026999 | 37037091 | 1.350 | 50000000 | 282.6 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019233 | 51991643 | 0.962 | 50000000 | 396.7 MB/s |
| nextwithkey | 0.019167 | 52169195 | 0.958 | 50000000 | 398.0 MB/s |
| nextwithkey | 0.019215 | 52038666 | 0.961 | 50000000 | 397.0 MB/s |
| readseq | 0.019912 | 50218601 | 0.996 | 50000000 | 383.1 MB/s |
| readseq | 0.020418 | 48972843 | 1.021 | 50000000 | 373.6 MB/s |
| readseq | 0.019900 | 50247822 | 0.995 | 50000000 | 383.4 MB/s |
RocksDB v8.10
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.459 | 685631 | 72.925 | 50000000 | 37.9 MB/s |
| compact | 21534271.000 | 0 | 21.534 | 1 | |
| readseq | 0.146 | 6855784 | 4.610 | 31605059 | 379.2 MB/s |
| readseq | 0.102 | 9773534 | 3.234 | 31605059 | 540.6 MB/s |
| readseq | 0.102 | 9779982 | 3.232 | 31605059 | 541.0 MB/s |
| readrandom | 2.908 | 343893 | 145.394 | 50000000 | 12.0 MB/s (31605541 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.354 | 2824299 | 17.704 | 50000000 | 156.2 MB/s |
| compact | 18078245.000 | 0 | 18.078 | 1 | |
| readseq | 0.167 | 5977439 | 8.365 | 50000000 | 330.6 MB/s |
| readseq | 0.102 | 9823221 | 5.090 | 50000000 | 543.4 MB/s |
| readseq | 0.102 | 9824280 | 5.089 | 50000000 | 543.4 MB/s |
| readrandom | 2.986 | 334846 | 149.322 | 50000000 | 18.5 MB/s (50000000 of 50000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 348352796 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.65404 MiB/s |
| fillrandom | write us/op | 3.48353 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 415928381 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 3.8979 MiB/s |
| readrandom | read us/op | 4.15928 |
RocksDB master (323d915d)
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.406 | 711274 | 70.296 | 50000000 | 39.3 MB/s |
| compact | 29840102.000 | 0 | 29.840 | 1 | |
| readseq | 0.174 | 5740663 | 5.505 | 31604440 | 317.5 MB/s |
| readseq | 0.119 | 8381955 | 3.771 | 31604440 | 463.6 MB/s |
| readseq | 0.124 | 8058492 | 3.922 | 31604440 | 445.7 MB/s |
| readrandom | 2.862 | 349399 | 143.103 | 50000000 | 12.2 MB/s (31603420 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.374 | 2675029 | 18.691 | 50000000 | 148.0 MB/s |
| compact | 19818100.000 | 0 | 19.818 | 1 | |
| readseq | 0.194 | 5158059 | 9.694 | 50000000 | 285.3 MB/s |
| readseq | 0.119 | 8391753 | 5.958 | 50000000 | 464.2 MB/s |
| readseq | 0.119 | 8402819 | 5.950 | 50000000 | 464.8 MB/s |
| readrandom | 3.050 | 327869 | 152.500 | 50000000 | 18.1 MB/s (50000000 of 50000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 354268426 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.57632 MiB/s |
| fillrandom | write us/op | 3.54268 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 407470935 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 3.9788 MiB/s |
| readrandom | read us/op | 4.07471 |