Result table: plain / 31914258669
← plain home |
dcompact →
generated (UTC): 2026-08-16 02:07:06+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=100000000 | key_size=8 | value_size=50
On-disk DB size (3.7GiB) ≤ 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.976281 | 1024294 | 97.628 | 100000000 | 56.7 MB/s |
| compact | 31941469.000000 | 0 | 31.942 | 1 | |
| readseq | 0.042269 | 23657843 | 4.227 | 100000000 | 1308.6 MB/s |
| readseq | 0.042167 | 23715115 | 4.217 | 100000000 | 1311.8 MB/s |
| readseq | 0.041708 | 23976181 | 4.171 | 100000000 | 1326.2 MB/s |
| readrandom | 0.233074 | 4290479 | 23.307 | 100000000 | 150.0 MB/s (63208702 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.425005 | 2352911 | 42.501 | 100000000 | 130.1 MB/s |
| compact | 38643393.000000 | 0 | 38.643 | 1 | |
| readseq | 0.032433 | 30831757 | 3.243 | 100000000 | 1705.4 MB/s |
| readseq | 0.032399 | 30865102 | 3.240 | 100000000 | 1707.2 MB/s |
| readseq | 0.032415 | 30849724 | 3.242 | 100000000 | 1706.4 MB/s |
| readrandom | 0.155043 | 6449824 | 15.504 | 100000000 | 356.8 MB/s (100000000 of 100000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026330 | 37978423 | 2.633 | 100000000 | 289.8 MB/s |
| nextwithkey | 0.026123 | 38278874 | 2.612 | 100000000 | 292.0 MB/s |
| nextwithkey | 0.026122 | 38281468 | 2.612 | 100000000 | 292.1 MB/s |
| readseq | 0.027533 | 36319616 | 2.753 | 100000000 | 277.1 MB/s |
| readseq | 0.027346 | 36567349 | 2.735 | 100000000 | 279.0 MB/s |
| readseq | 0.027546 | 36302450 | 2.755 | 100000000 | 277.0 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019281 | 51863131 | 1.928 | 100000000 | 395.7 MB/s |
| nextwithkey | 0.019135 | 52259955 | 1.914 | 100000000 | 398.7 MB/s |
| nextwithkey | 0.019143 | 52235714 | 1.914 | 100000000 | 398.5 MB/s |
| readseq | 0.019864 | 50341618 | 1.986 | 100000000 | 384.1 MB/s |
| readseq | 0.019859 | 50354191 | 1.986 | 100000000 | 384.2 MB/s |
| readseq | 0.019865 | 50337842 | 1.987 | 100000000 | 384.0 MB/s |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 347540664 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.66491 MiB/s |
| fillrandom | write us/op | 3.47541 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 374117542 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 4.33352 MiB/s |
| readrandom | read us/op | 3.74118 |
memtablerep_bench (cspp, ToplingDB only)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 38124950 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 42.5245 MiB/s |
| fillrandom | write us/op | 0.38125 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 54127694 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 29.9523 MiB/s |
| readrandom | read us/op | 0.541277 |
ToplingDB zipkeyvalue
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 0.990064 | 1010002 | 99.010 | 100000000 | 55.9 MB/s |
| compact | 77321229.000000 | 0 | 77.321 | 1 | |
| readseq | 0.059446 | 16821955 | 5.945 | 100000000 | 930.5 MB/s |
| readseq | 0.059220 | 16886084 | 5.922 | 100000000 | 934.0 MB/s |
| readseq | 0.059353 | 16848095 | 5.935 | 100000000 | 931.9 MB/s |
| readrandom | 0.621753 | 1608353 | 62.175 | 100000000 | 56.2 MB/s (63211648 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.423408 | 2361786 | 42.341 | 100000000 | 130.6 MB/s |
| compact | 123428582.000000 | 0 | 123.429 | 1 | |
| readseq | 0.049362 | 20258321 | 4.936 | 100000000 | 1120.6 MB/s |
| readseq | 0.048559 | 20593441 | 4.856 | 100000000 | 1139.1 MB/s |
| readseq | 0.048541 | 20600742 | 4.854 | 100000000 | 1139.5 MB/s |
| readrandom | 0.796865 | 1254917 | 79.687 | 100000000 | 69.4 MB/s (100000000 of 100000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026146 | 38245524 | 2.615 | 100000000 | 291.8 MB/s |
| nextwithkey | 0.026264 | 38073568 | 2.626 | 100000000 | 290.5 MB/s |
| nextwithkey | 0.026169 | 38213138 | 2.617 | 100000000 | 291.5 MB/s |
| readseq | 0.027184 | 36785708 | 2.718 | 100000000 | 280.7 MB/s |
| readseq | 0.027396 | 36500493 | 2.740 | 100000000 | 278.5 MB/s |
| readseq | 0.027270 | 36669674 | 2.727 | 100000000 | 279.8 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019194 | 52097877 | 1.919 | 100000000 | 397.5 MB/s |
| nextwithkey | 0.019131 | 52270199 | 1.913 | 100000000 | 398.8 MB/s |
| nextwithkey | 0.019277 | 51873273 | 1.928 | 100000000 | 395.8 MB/s |
| readseq | 0.019866 | 50334447 | 1.987 | 100000000 | 384.0 MB/s |
| readseq | 0.019883 | 50292197 | 1.988 | 100000000 | 383.7 MB/s |
| readseq | 0.019884 | 50289542 | 1.988 | 100000000 | 383.7 MB/s |
RocksDB v8.10
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.476 | 677484 | 147.605 | 100000000 | 37.5 MB/s |
| compact | 44782722.000 | 0 | 44.783 | 1 | |
| readseq | 0.146 | 6868299 | 9.204 | 63213955 | 379.9 MB/s |
| readseq | 0.100 | 9976080 | 6.337 | 63213955 | 551.8 MB/s |
| readseq | 0.100 | 9969419 | 6.341 | 63213955 | 551.4 MB/s |
| readrandom | 3.037 | 329311 | 303.664 | 100000000 | 11.5 MB/s (63207453 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.355 | 2814783 | 35.527 | 100000000 | 155.7 MB/s |
| compact | 35844710.000 | 0 | 35.845 | 1 | |
| readseq | 0.170 | 5874829 | 17.022 | 100000000 | 325.0 MB/s |
| readseq | 0.100 | 9999738 | 10.000 | 100000000 | 553.1 MB/s |
| readseq | 0.100 | 10010281 | 9.990 | 100000000 | 553.7 MB/s |
| readrandom | 3.129 | 319610 | 312.881 | 100000000 | 17.7 MB/s (100000000 of 100000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 325857807 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.97532 MiB/s |
| fillrandom | write us/op | 3.25858 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 368893590 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 4.39489 MiB/s |
| readrandom | read us/op | 3.68894 |
RocksDB master (323d915d)
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.517 | 659411 | 151.650 | 100000000 | 36.5 MB/s |
| compact | 65079203.000 | 0 | 65.079 | 1 | |
| readseq | 0.173 | 5769343 | 10.956 | 63207663 | 319.1 MB/s |
| readseq | 0.119 | 8387595 | 7.536 | 63207663 | 463.9 MB/s |
| readseq | 0.119 | 8393861 | 7.530 | 63207663 | 464.3 MB/s |
| readrandom | 3.073 | 325444 | 307.272 | 100000000 | 11.4 MB/s (63202032 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.368 | 2714850 | 36.834 | 100000000 | 150.2 MB/s |
| compact | 37083328.000 | 0 | 37.083 | 1 | |
| readseq | 0.196 | 5109871 | 19.570 | 100000000 | 282.6 MB/s |
| readseq | 0.119 | 8369231 | 11.949 | 100000000 | 462.9 MB/s |
| readseq | 0.120 | 8342763 | 11.986 | 100000000 | 461.5 MB/s |
| readrandom | 3.242 | 308447 | 324.205 | 100000000 | 17.1 MB/s (100000000 of 100000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 330242274 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.90926 MiB/s |
| fillrandom | write us/op | 3.30242 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 377159933 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 4.29856 MiB/s |
| readrandom | read us/op | 3.7716 |