Result table: plain / 31866312589
← plain home |
dcompact →
generated (UTC): 2026-08-15 06:19:56+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.937725 | 1066409 | 46.886 | 50000000 | 59.0 MB/s |
| compact | 14586039.000000 | 0 | 14.586 | 1 | |
| readseq | 0.042906 | 23305829 | 2.145 | 50000000 | 1289.1 MB/s |
| readseq | 0.042464 | 23549082 | 2.123 | 50000000 | 1302.6 MB/s |
| readseq | 0.042736 | 23399410 | 2.137 | 50000000 | 1294.3 MB/s |
| readrandom | 0.283021 | 3533276 | 14.151 | 50000000 | 123.6 MB/s (31608781 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.413114 | 2420633 | 20.656 | 50000000 | 133.9 MB/s |
| compact | 19762548.000000 | 0 | 19.763 | 1 | |
| readseq | 0.033823 | 29564963 | 1.691 | 50000000 | 1635.3 MB/s |
| readseq | 0.034222 | 29220098 | 1.711 | 50000000 | 1616.3 MB/s |
| readseq | 0.034225 | 29217485 | 1.711 | 50000000 | 1616.1 MB/s |
| readrandom | 0.151174 | 6614818 | 7.559 | 50000000 | 365.9 MB/s (50000000 of 50000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026705 | 37444544 | 1.335 | 50000000 | 285.7 MB/s |
| nextwithkey | 0.026604 | 37588106 | 1.330 | 50000000 | 286.8 MB/s |
| nextwithkey | 0.026585 | 37613215 | 1.329 | 50000000 | 287.0 MB/s |
| readseq | 0.027312 | 36612736 | 1.366 | 50000000 | 279.3 MB/s |
| readseq | 0.027337 | 36579067 | 1.367 | 50000000 | 279.1 MB/s |
| readseq | 0.027343 | 36570960 | 1.367 | 50000000 | 279.0 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019393 | 51562498 | 0.970 | 50000000 | 393.4 MB/s |
| nextwithkey | 0.019310 | 51783260 | 0.966 | 50000000 | 395.1 MB/s |
| nextwithkey | 0.019345 | 51690325 | 0.967 | 50000000 | 394.4 MB/s |
| readseq | 0.020093 | 49766594 | 1.005 | 50000000 | 379.7 MB/s |
| readseq | 0.019977 | 50053958 | 0.999 | 50000000 | 381.9 MB/s |
| readseq | 0.019958 | 50102760 | 0.998 | 50000000 | 382.3 MB/s |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 372559346 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.35165 MiB/s |
| fillrandom | write us/op | 3.72559 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 421397093 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 3.84731 MiB/s |
| readrandom | read us/op | 4.21397 |
memtablerep_bench (cspp, ToplingDB only)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 40111930 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 40.4181 MiB/s |
| fillrandom | write us/op | 0.401119 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 54989312 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 29.4829 MiB/s |
| readrandom | read us/op | 0.549893 |
ToplingDB zipkeyvalue
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 0.868105 | 1151933 | 43.405 | 50000000 | 63.7 MB/s |
| compact | 40146626.000000 | 0 | 40.147 | 1 | |
| readseq | 0.060205 | 16609551 | 3.010 | 50000000 | 918.7 MB/s |
| readseq | 0.059827 | 16714503 | 2.991 | 50000000 | 924.5 MB/s |
| readseq | 0.059306 | 16861410 | 2.965 | 50000000 | 932.7 MB/s |
| readrandom | 0.697663 | 1433355 | 34.883 | 50000000 | 50.1 MB/s (31603762 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.407220 | 2455673 | 20.361 | 50000000 | 135.8 MB/s |
| compact | 65634098.000000 | 0 | 65.634 | 1 | |
| readseq | 0.050597 | 19763462 | 2.530 | 50000000 | 1093.2 MB/s |
| readseq | 0.048861 | 20465818 | 2.443 | 50000000 | 1132.0 MB/s |
| readseq | 0.048604 | 20574209 | 2.430 | 50000000 | 1138.0 MB/s |
| readrandom | 0.878777 | 1137944 | 43.939 | 50000000 | 62.9 MB/s (50000000 of 50000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026133 | 38263773 | 1.307 | 50000000 | 291.9 MB/s |
| nextwithkey | 0.026002 | 38456598 | 1.300 | 50000000 | 293.4 MB/s |
| nextwithkey | 0.026010 | 38446544 | 1.301 | 50000000 | 293.3 MB/s |
| readseq | 0.026959 | 37090777 | 1.348 | 50000000 | 283.0 MB/s |
| readseq | 0.026962 | 37087448 | 1.348 | 50000000 | 283.0 MB/s |
| readseq | 0.026905 | 37165215 | 1.345 | 50000000 | 283.5 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019277 | 51874376 | 0.964 | 50000000 | 395.8 MB/s |
| nextwithkey | 0.019171 | 52159290 | 0.959 | 50000000 | 397.9 MB/s |
| nextwithkey | 0.019151 | 52213377 | 0.958 | 50000000 | 398.4 MB/s |
| readseq | 0.019889 | 50276015 | 0.995 | 50000000 | 383.6 MB/s |
| readseq | 0.019848 | 50380676 | 0.992 | 50000000 | 384.4 MB/s |
| readseq | 0.019867 | 50331381 | 0.993 | 50000000 | 384.0 MB/s |
RocksDB v8.10
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.958 | 510653 | 97.914 | 50000000 | 28.2 MB/s |
| compact | 19356360.000 | 0 | 19.356 | 1 | |
| readseq | 0.148 | 6763288 | 4.674 | 31608738 | 374.1 MB/s |
| readseq | 0.101 | 9937323 | 3.181 | 31608738 | 549.7 MB/s |
| readseq | 0.101 | 9910866 | 3.189 | 31608738 | 548.2 MB/s |
| readrandom | 3.148 | 317666 | 157.398 | 50000000 | 11.1 MB/s (31607431 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.248 | 4032799 | 12.398 | 50000000 | 223.1 MB/s |
| compact | 18158768.000 | 0 | 18.159 | 1 | |
| readseq | 0.167 | 5988594 | 8.349 | 50000000 | 331.2 MB/s |
| readseq | 0.100 | 9960318 | 5.020 | 50000000 | 550.9 MB/s |
| readseq | 0.101 | 9915120 | 5.043 | 50000000 | 548.4 MB/s |
| readrandom | 3.317 | 301506 | 165.834 | 50000000 | 16.7 MB/s (50000000 of 50000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 407097226 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 3.98245 MiB/s |
| fillrandom | write us/op | 4.07097 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 452138807 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 3.58573 MiB/s |
| readrandom | read us/op | 4.52139 |
RocksDB master (323d915d)
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.862 | 536932 | 93.122 | 50000000 | 29.7 MB/s |
| compact | 20000467.000 | 0 | 20.000 | 1 | |
| readseq | 0.175 | 5700071 | 5.545 | 31604185 | 315.3 MB/s |
| readseq | 0.120 | 8333588 | 3.792 | 31604185 | 461.0 MB/s |
| readseq | 0.120 | 8339629 | 3.790 | 31604185 | 461.3 MB/s |
| readrandom | 3.239 | 308747 | 161.944 | 50000000 | 10.8 MB/s (31598133 of 50000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.254 | 3941086 | 12.687 | 50000000 | 218.0 MB/s |
| compact | 18795971.000 | 0 | 18.796 | 1 | |
| readseq | 0.194 | 5148817 | 9.711 | 50000000 | 284.8 MB/s |
| readseq | 0.120 | 8351389 | 5.987 | 50000000 | 461.9 MB/s |
| readseq | 0.120 | 8343175 | 5.993 | 50000000 | 461.5 MB/s |
| readrandom | 3.366 | 297094 | 168.296 | 50000000 | 16.4 MB/s (50000000 of 50000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 394149730 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.11328 MiB/s |
| fillrandom | write us/op | 3.9415 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 445617176 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 3.6382 MiB/s |
| readrandom | read us/op | 4.45617 |