Result table: plain / 34770497158

← plain home | dcompact →

generated (UTC): 2026-09-13 18:28:04+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.58x 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.605143	1652500	60.514	100000000	91.4 MB/s
compact	43959793.000000	0	43.960	1
readseq	0.034230	29213832	3.423	100000000	1615.9 MB/s
readseq	0.032984	30316976	3.298	100000000	1676.9 MB/s
readseq	0.032954	30344639	3.295	100000000	1678.5 MB/s
readrandom	0.181545	5508252	18.155	100000000	192.6 MB/s (63204506 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.257802	3878935	25.780	100000000	214.6 MB/s
compact	35489726.000000	0	35.490	1
readseq	0.026073	38352837	2.607	100000000	2121.4 MB/s
readseq	0.026362	37933000	2.636	100000000	2098.2 MB/s
readseq	0.026723	37420528	2.672	100000000	2069.8 MB/s
readrandom	0.121109	8256960	12.111	100000000	456.7 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019839	50406299	1.984	100000000	384.6 MB/s
nextwithkey	0.019848	50380600	1.985	100000000	384.4 MB/s
nextwithkey	0.019832	50421651	1.983	100000000	384.7 MB/s
readseq	0.021054	47495807	2.105	100000000	362.4 MB/s
readseq	0.021267	47019791	2.127	100000000	358.7 MB/s
readseq	0.021041	47524948	2.104	100000000	362.6 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.014988	66718084	1.499	100000000	509.0 MB/s
nextwithkey	0.015071	66348635	1.507	100000000	506.2 MB/s
nextwithkey	0.014944	66914338	1.494	100000000	510.5 MB/s
readseq	0.015469	64642578	1.547	100000000	493.2 MB/s
readseq	0.015462	64670545	1.546	100000000	493.4 MB/s
readseq	0.015454	64705737	1.545	100000000	493.7 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	300457330 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.39593 MiB/s
fillrandom	write us/op	3.00457
readrandom	Number of threads	1
readrandom	Elapsed time	367955133 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.4061 MiB/s
readrandom	read us/op	3.67955

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	33660898 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	48.1641 MiB/s
fillrandom	write us/op	0.336609
readrandom	Number of threads	1
readrandom	Elapsed time	51227143 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	31.6482 MiB/s
readrandom	read us/op	0.512271

memtablerep_bench (OffsetSkipList, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	241186004 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.72198 MiB/s
fillrandom	write us/op	2.41186
readrandom	Number of threads	1
readrandom	Elapsed time	290839865 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	5.57436 MiB/s
readrandom	read us/op	2.9084

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	0.569489	1755959	56.949	100000000	97.1 MB/s
compact	53472325.000000	0	53.472	1
readseq	0.045853	21808842	4.585	100000000	1206.3 MB/s
readseq	0.045419	22017101	4.542	100000000	1217.8 MB/s
readseq	0.045888	21792104	4.589	100000000	1205.4 MB/s
readrandom	0.563186	1775610	56.319	100000000	62.1 MB/s (63204785 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.257071	3889939	25.707	100000000	215.2 MB/s
compact	106127976.000000	0	106.128	1
readseq	0.038126	26228586	3.813	100000000	1450.8 MB/s
readseq	0.037427	26718521	3.743	100000000	1477.9 MB/s
readseq	0.037527	26646876	3.753	100000000	1473.9 MB/s
readrandom	0.741357	1348877	74.136	100000000	74.6 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.020153	49620625	2.015	100000000	378.6 MB/s
nextwithkey	0.019825	50441260	1.983	100000000	384.8 MB/s
nextwithkey	0.020827	48012613	2.083	100000000	366.3 MB/s
readseq	0.021093	47407272	2.109	100000000	361.7 MB/s
readseq	0.022454	44534701	2.245	100000000	339.8 MB/s
readseq	0.021236	47089026	2.124	100000000	359.3 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.015175	65894254	1.518	100000000	502.7 MB/s
nextwithkey	0.014993	66694633	1.499	100000000	508.8 MB/s
nextwithkey	0.014926	66994627	1.493	100000000	511.1 MB/s
readseq	0.015454	64707370	1.545	100000000	493.7 MB/s
readseq	0.015437	64778418	1.544	100000000	494.2 MB/s
readseq	0.015470	64640071	1.547	100000000	493.2 MB/s

RocksDB v8.10

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.256	795912	125.642	100000000	44.0 MB/s
compact	46171284.000	0	46.171	1
readseq	0.115	8687369	7.277	63214264	480.5 MB/s
readseq	0.080	12487727	5.062	63214264	690.7 MB/s
readseq	0.080	12483535	5.064	63214264	690.5 MB/s
readrandom	2.582	387324	258.182	100000000	13.5 MB/s (63213930 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.278	3603407	27.752	100000000	199.3 MB/s
compact	28297009.000	0	28.297	1
readseq	0.135	7404775	13.505	100000000	409.6 MB/s
readseq	0.080	12511072	7.993	100000000	692.0 MB/s
readseq	0.080	12525177	7.984	100000000	692.8 MB/s
readrandom	2.633	379741	263.337	100000000	21.0 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	305187567 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.31229 MiB/s
fillrandom	write us/op	3.05188
readrandom	Number of threads	1
readrandom	Elapsed time	353768774 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.58279 MiB/s
readrandom	read us/op	3.53769

RocksDB master (7a90dc5b)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.201	832451	120.127	100000000	46.0 MB/s
compact	51352459.000	0	51.352	1
readseq	0.141	7076486	8.933	63210908	391.4 MB/s
readseq	0.096	10410816	6.072	63210908	575.9 MB/s
readseq	0.096	10417145	6.068	63210908	576.2 MB/s
readrandom	2.511	398196	251.132	100000000	13.9 MB/s (63213747 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.289	3464047	28.868	100000000	191.6 MB/s
compact	29189884.000	0	29.190	1
readseq	0.161	6228908	16.054	100000000	344.5 MB/s
readseq	0.096	10422884	9.594	100000000	576.5 MB/s
readseq	0.096	10380148	9.634	100000000	574.2 MB/s
readrandom	2.718	367873	271.833	100000000	20.3 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	301506583 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.37715 MiB/s
fillrandom	write us/op	3.01507
readrandom	Number of threads	1
readrandom	Elapsed time	395871272 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.09539 MiB/s
readrandom	read us/op	3.95871