Result table: plain / 31914256719
← plain home |
dcompact →
generated (UTC): 2026-08-16 00:41:41+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.988192 | 1011946 | 98.819 | 100000000 | 56.0 MB/s |
| compact | 33435740.000000 | 0 | 33.436 | 1 | |
| readseq | 0.041547 | 24069178 | 4.155 | 100000000 | 1331.3 MB/s |
| readseq | 0.041718 | 23970002 | 4.172 | 100000000 | 1325.9 MB/s |
| readseq | 0.042290 | 23646022 | 4.229 | 100000000 | 1307.9 MB/s |
| readrandom | 0.296151 | 3376653 | 29.615 | 100000000 | 118.1 MB/s (63218440 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.422295 | 2368009 | 42.230 | 100000000 | 131.0 MB/s |
| compact | 38771126.000000 | 0 | 38.771 | 1 | |
| readseq | 0.032527 | 30743292 | 3.253 | 100000000 | 1700.5 MB/s |
| readseq | 0.032727 | 30555212 | 3.273 | 100000000 | 1690.1 MB/s |
| readseq | 0.032544 | 30727413 | 3.254 | 100000000 | 1699.6 MB/s |
| readrandom | 0.155299 | 6439161 | 15.530 | 100000000 | 356.2 MB/s (100000000 of 100000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026149 | 38241546 | 2.615 | 100000000 | 291.8 MB/s |
| nextwithkey | 0.026086 | 38333166 | 2.609 | 100000000 | 292.5 MB/s |
| nextwithkey | 0.026098 | 38315335 | 2.610 | 100000000 | 292.3 MB/s |
| readseq | 0.026927 | 37135887 | 2.693 | 100000000 | 283.3 MB/s |
| readseq | 0.026917 | 37150566 | 2.692 | 100000000 | 283.4 MB/s |
| readseq | 0.027238 | 36712889 | 2.724 | 100000000 | 280.1 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019146 | 52228675 | 1.915 | 100000000 | 398.5 MB/s |
| nextwithkey | 0.019131 | 52269980 | 1.913 | 100000000 | 398.8 MB/s |
| nextwithkey | 0.019122 | 52294362 | 1.912 | 100000000 | 399.0 MB/s |
| readseq | 0.020852 | 47954983 | 2.085 | 100000000 | 365.9 MB/s |
| readseq | 0.019987 | 50030593 | 1.999 | 100000000 | 381.7 MB/s |
| readseq | 0.020049 | 49875311 | 2.005 | 100000000 | 380.5 MB/s |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 322190205 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 5.03195 MiB/s |
| fillrandom | write us/op | 3.2219 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 370225763 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 4.37907 MiB/s |
| readrandom | read us/op | 3.70226 |
memtablerep_bench (cspp, ToplingDB only)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 37168612 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 43.6187 MiB/s |
| fillrandom | write us/op | 0.371686 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 55068405 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 29.4406 MiB/s |
| readrandom | read us/op | 0.550684 |
ToplingDB zipkeyvalue
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.008056 | 991989 | 100.808 | 100000000 | 54.9 MB/s |
| compact | 79774587.000000 | 0 | 79.775 | 1 | |
| readseq | 0.059184 | 16896230 | 5.918 | 100000000 | 934.6 MB/s |
| readseq | 0.059179 | 16897689 | 5.918 | 100000000 | 934.7 MB/s |
| readseq | 0.058495 | 17095238 | 5.850 | 100000000 | 945.6 MB/s |
| readrandom | 0.726375 | 1376698 | 72.638 | 100000000 | 48.1 MB/s (63213680 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.422486 | 2366938 | 42.249 | 100000000 | 130.9 MB/s |
| compact | 123837426.000000 | 0 | 123.837 | 1 | |
| readseq | 0.049111 | 20361017 | 4.911 | 100000000 | 1126.2 MB/s |
| readseq | 0.048204 | 20744791 | 4.820 | 100000000 | 1147.5 MB/s |
| readseq | 0.048249 | 20725723 | 4.825 | 100000000 | 1146.4 MB/s |
| readrandom | 0.723015 | 1383096 | 72.302 | 100000000 | 76.5 MB/s (100000000 of 100000000 found) |
db_bench omit lazy-load (fillrandom DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.026179 | 38197403 | 2.618 | 100000000 | 291.4 MB/s |
| nextwithkey | 0.026099 | 38315291 | 2.610 | 100000000 | 292.3 MB/s |
| nextwithkey | 0.026106 | 38305164 | 2.611 | 100000000 | 292.2 MB/s |
| readseq | 0.026927 | 37136852 | 2.693 | 100000000 | 283.3 MB/s |
| readseq | 0.027228 | 36726129 | 2.723 | 100000000 | 280.2 MB/s |
| readseq | 0.027275 | 36663315 | 2.728 | 100000000 | 279.7 MB/s |
db_bench omit lazy-load (fillseq DB)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| nextwithkey | 0.019167 | 52172706 | 1.917 | 100000000 | 398.0 MB/s |
| nextwithkey | 0.019132 | 52263670 | 1.913 | 100000000 | 398.7 MB/s |
| nextwithkey | 0.019287 | 51847212 | 1.929 | 100000000 | 395.6 MB/s |
| readseq | 0.019890 | 50275661 | 1.989 | 100000000 | 383.6 MB/s |
| readseq | 0.019843 | 50394107 | 1.984 | 100000000 | 384.5 MB/s |
| readseq | 0.019841 | 50398958 | 1.984 | 100000000 | 384.5 MB/s |
RocksDB v8.10
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.466 | 681924 | 146.644 | 100000000 | 37.7 MB/s |
| compact | 43104883.000 | 0 | 43.105 | 1 | |
| readseq | 0.146 | 6857590 | 9.218 | 63210870 | 379.3 MB/s |
| readseq | 0.102 | 9797819 | 6.452 | 63210870 | 541.9 MB/s |
| readseq | 0.102 | 9763508 | 6.474 | 63210870 | 540.1 MB/s |
| readrandom | 3.031 | 329938 | 303.087 | 100000000 | 11.5 MB/s (63203491 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.363 | 2752397 | 36.332 | 100000000 | 152.2 MB/s |
| compact | 35791798.000 | 0 | 35.792 | 1 | |
| readseq | 0.172 | 5823924 | 17.171 | 100000000 | 322.1 MB/s |
| readseq | 0.102 | 9807283 | 10.197 | 100000000 | 542.5 MB/s |
| readseq | 0.102 | 9769041 | 10.236 | 100000000 | 540.4 MB/s |
| readrandom | 3.104 | 322166 | 310.399 | 100000000 | 17.8 MB/s (100000000 of 100000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 343088534 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 4.72545 MiB/s |
| fillrandom | write us/op | 3.43089 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 375570017 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 4.31676 MiB/s |
| readrandom | read us/op | 3.7557 |
RocksDB master (323d915d)
db_bench (fillrandom+compact+readseq/readrandom)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillrandom | 1.505 | 664561 | 150.475 | 100000000 | 36.8 MB/s |
| compact | 66415450.000 | 0 | 66.415 | 1 | |
| readseq | 0.176 | 5695627 | 11.099 | 63218220 | 315.0 MB/s |
| readseq | 0.122 | 8200842 | 7.709 | 63218220 | 453.6 MB/s |
| readseq | 0.122 | 8207602 | 7.702 | 63218220 | 454.0 MB/s |
| readrandom | 3.269 | 305865 | 326.941 | 100000000 | 10.7 MB/s (63216261 of 100000000 found) |
db_bench (fillseq suite)
| benchmark | micros/op | ops/sec | seconds | operations | extra |
|---|
| fillseq | 0.371 | 2694194 | 37.117 | 100000000 | 149.0 MB/s |
| compact | 37126253.000 | 0 | 37.126 | 1 | |
| readseq | 0.196 | 5114891 | 19.551 | 100000000 | 282.9 MB/s |
| readseq | 0.120 | 8311666 | 12.031 | 100000000 | 459.7 MB/s |
| readseq | 0.121 | 8292083 | 12.060 | 100000000 | 458.7 MB/s |
| readrandom | 3.351 | 298415 | 335.103 | 100000000 | 16.5 MB/s (100000000 of 100000000 found) |
memtablerep_bench (skiplist)
| benchmark | metric | value |
|---|
| fillrandom | Number of threads | 1 |
| fillrandom | Elapsed time | 321518362 us |
| fillrandom | Total bytes written | 1621.25 MiB |
| fillrandom | Write throughput | 5.04247 MiB/s |
| fillrandom | write us/op | 3.21518 |
| readrandom | Number of threads | 1 |
| readrandom | Elapsed time | 370410331 us |
| readrandom | Total bytes read | 1621.25 MiB |
| readrandom | Read throughput | 4.37689 MiB/s |
| readrandom | read us/op | 3.7041 |