Result table: plain / 34708681171

← plain home | dcompact →

generated (UTC): 2026-09-12 19:11:46+00:00

raw logs: ToplingDB zipkeyonly | ToplingDB zipkeyvalue | RocksDB v8.10 | RocksDB master (7a90dc5b) | 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.5 LTS
Kernel	6.17.0-1022-azure
CPU	AMD EPYC 9V74 80-Core Processor
Logical CPUs	4
Memory	15.6GiB
/dev/shm	11.7GiB
RocksDB block cache	7.8GiB

num=100000000 | key_size=8 | value_size=50

On-disk DB size (3.7GiB) ≤ block cache (7.8GiB) — the dataset fits in cache, so this bench is a CPU and memory comparison.

On readrandom (the fairest comparison), ToplingDB zipkeyvalue is 14% memory / 4.73x speed vs RocksDB v8.10.
In production the working set typically does not fit, so cache misses dominate. The same RAM holds more ToplingDB data, which cuts I/O and widens the gap.
ToplingDB dcompact can offload most of that CPU and memory cost.

ToplingDB zipkeyonly

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	0.762465	1311534	76.247	100000000	72.5 MB/s
compact	42756453.000000	0	42.756	1
readseq	0.042241	23673446	4.224	100000000	1309.5 MB/s
readseq	0.042489	23535281	4.249	100000000	1301.8 MB/s
readseq	0.042331	23622835	4.233	100000000	1306.7 MB/s
readrandom	0.273118	3661418	27.312	100000000	128.0 MB/s (63211479 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.305443	3273896	30.545	100000000	181.1 MB/s
compact	40170482.000000	0	40.171	1
readseq	0.032429	30836672	3.243	100000000	1705.7 MB/s
readseq	0.032720	30561609	3.272	100000000	1690.5 MB/s
readseq	0.032826	30462858	3.283	100000000	1685.0 MB/s
readrandom	0.149782	6676358	14.978	100000000	369.3 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025923	38575038	2.592	100000000	294.3 MB/s
nextwithkey	0.025904	38602660	2.590	100000000	294.5 MB/s
nextwithkey	0.026006	38451038	2.601	100000000	293.4 MB/s
readseq	0.027163	36813741	2.716	100000000	280.9 MB/s
readseq	0.027179	36792124	2.718	100000000	280.7 MB/s
readseq	0.027212	36747196	2.721	100000000	280.4 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019171	52161466	1.917	100000000	398.0 MB/s
nextwithkey	0.019169	52164215	1.917	100000000	398.0 MB/s
nextwithkey	0.019156	52202665	1.916	100000000	398.3 MB/s
readseq	0.020047	49880784	2.005	100000000	380.6 MB/s
readseq	0.019882	50294980	1.988	100000000	383.7 MB/s
readseq	0.019922	50195738	1.992	100000000	383.0 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	349382558 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.64032 MiB/s
fillrandom	write us/op	3.49383
readrandom	Number of threads	1
readrandom	Elapsed time	428878731 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	3.7802 MiB/s
readrandom	read us/op	4.28879

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	38462631 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	42.1512 MiB/s
fillrandom	write us/op	0.384626
readrandom	Number of threads	1
readrandom	Elapsed time	55927175 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	28.9885 MiB/s
readrandom	read us/op	0.559272

memtablerep_bench (OffsetSkipList, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	319333639 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.07697 MiB/s
fillrandom	write us/op	3.19334
readrandom	Number of threads	1
readrandom	Elapsed time	346156073 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.68357 MiB/s
readrandom	read us/op	3.46156

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	0.710148	1408154	71.015	100000000	77.9 MB/s
compact	68088969.000000	0	68.089	1
readseq	0.059793	16724346	5.979	100000000	925.1 MB/s
readseq	0.060316	16579288	6.032	100000000	917.1 MB/s
readseq	0.058397	17124167	5.840	100000000	947.2 MB/s
readrandom	0.632480	1581075	63.248	100000000	55.3 MB/s (63212322 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.310226	3223450	31.023	100000000	178.3 MB/s
compact	125811508.000000	0	125.812	1
readseq	0.049419	20234771	4.942	100000000	1119.2 MB/s
readseq	0.049870	20051797	4.987	100000000	1109.1 MB/s
readseq	0.048538	20602083	4.854	100000000	1139.6 MB/s
readrandom	0.789327	1266901	78.933	100000000	70.1 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025850	38683642	2.585	100000000	295.1 MB/s
nextwithkey	0.031270	31978633	3.127	100000000	244.0 MB/s
nextwithkey	0.025688	38929000	2.569	100000000	297.0 MB/s
readseq	0.026933	37128786	2.693	100000000	283.3 MB/s
readseq	0.026930	37132426	2.693	100000000	283.3 MB/s
readseq	0.026938	37121398	2.694	100000000	283.2 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019196	52093155	1.920	100000000	397.4 MB/s
nextwithkey	0.019140	52245812	1.914	100000000	398.6 MB/s
nextwithkey	0.019145	52229821	1.915	100000000	398.5 MB/s
readseq	0.019904	50239365	1.990	100000000	383.3 MB/s
readseq	0.019879	50303809	1.988	100000000	383.8 MB/s
readseq	0.020146	49635600	2.015	100000000	378.7 MB/s

RocksDB v8.10

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.501	666035	150.142	100000000	36.8 MB/s
compact	47529602.000	0	47.530	1
readseq	0.145	6880515	9.188	63215140	380.6 MB/s
readseq	0.102	9820108	6.437	63215140	543.2 MB/s
readseq	0.102	9766047	6.473	63215140	540.2 MB/s
readrandom	2.992	334231	299.194	100000000	11.7 MB/s (63206779 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.359	2785793	35.896	100000000	154.1 MB/s
compact	35879180.000	0	35.879	1
readseq	0.168	5941152	16.832	100000000	328.6 MB/s
readseq	0.101	9855254	10.147	100000000	545.1 MB/s
readseq	0.102	9847916	10.154	100000000	544.7 MB/s
readrandom	3.200	312496	320.003	100000000	17.3 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	345846547 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.68776 MiB/s
fillrandom	write us/op	3.45847
readrandom	Number of threads	1
readrandom	Elapsed time	394060429 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.11421 MiB/s
readrandom	read us/op	3.9406

RocksDB master (7a90dc5b)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.547	646364	154.712	100000000	35.8 MB/s
compact	43485341.000	0	43.485	1
readseq	0.177	5646598	11.194	63208662	312.3 MB/s
readseq	0.126	7918911	7.982	63208662	438.0 MB/s
readseq	0.126	7914624	7.986	63208662	437.8 MB/s
readrandom	3.030	330060	302.975	100000000	11.5 MB/s (63214448 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.371	2694784	37.109	100000000	149.1 MB/s
compact	38623001.000	0	38.623	1
readseq	0.199	5030508	19.879	100000000	278.3 MB/s
readseq	0.122	8165374	12.247	100000000	451.7 MB/s
readseq	0.123	8139001	12.287	100000000	450.2 MB/s
readrandom	3.138	318690	313.784	100000000	17.6 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	328374039 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.93719 MiB/s
fillrandom	write us/op	3.28374
readrandom	Number of threads	1
readrandom	Elapsed time	393233729 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.12286 MiB/s
readrandom	read us/op	3.93234