Result table: plain / 31957895530

← plain home | dcompact →

generated (UTC): 2026-08-16 17:28:08+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 7763 64-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) — the dataset fits in cache, so this bench is a CPU and memory comparison.

On readrandom (the fairest comparison), ToplingDB zipkeyvalue is 15% memory / 5.26x 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	1.006771	993274	100.677	100000000	54.9 MB/s
compact	28655271.000000	0	28.655	1
readseq	0.039910	25055893	3.991	100000000	1385.9 MB/s
readseq	0.040179	24888765	4.018	100000000	1376.7 MB/s
readseq	0.039960	25024724	3.996	100000000	1384.2 MB/s
readrandom	0.206141	4851034	20.614	100000000	169.6 MB/s (63204035 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.433639	2306063	43.364	100000000	127.6 MB/s
compact	41136955.000000	0	41.137	1
readseq	0.032474	30793628	3.247	100000000	1703.3 MB/s
readseq	0.032677	30602246	3.268	100000000	1692.7 MB/s
readseq	0.032645	30631783	3.265	100000000	1694.3 MB/s
readrandom	0.150542	6642651	15.054	100000000	367.4 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025165	39736815	2.517	100000000	303.2 MB/s
nextwithkey	0.025302	39522645	2.530	100000000	301.5 MB/s
nextwithkey	0.025131	39791302	2.513	100000000	303.6 MB/s
readseq	0.025790	38774042	2.579	100000000	295.8 MB/s
readseq	0.025819	38730641	2.582	100000000	295.5 MB/s
readseq	0.025801	38756805	2.580	100000000	295.7 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019153	52209288	1.915	100000000	398.3 MB/s
nextwithkey	0.019255	51934049	1.926	100000000	396.2 MB/s
nextwithkey	0.019036	52530030	1.904	100000000	400.8 MB/s
readseq	0.019461	51383817	1.946	100000000	392.0 MB/s
readseq	0.019485	51321898	1.948	100000000	391.6 MB/s
readseq	0.019464	51375528	1.946	100000000	392.0 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	257634997 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.2928 MiB/s
fillrandom	write us/op	2.57635
readrandom	Number of threads	1
readrandom	Elapsed time	319848739 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	5.06879 MiB/s
readrandom	read us/op	3.19849

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	32461656 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	49.9434 MiB/s
fillrandom	write us/op	0.324617
readrandom	Number of threads	1
readrandom	Elapsed time	43778868 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	37.0326 MiB/s
readrandom	read us/op	0.437789

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.009344	990742	100.934	100000000	54.8 MB/s
compact	77165459.000000	0	77.165	1
readseq	0.059432	16825943	5.943	100000000	930.7 MB/s
readseq	0.058986	16952945	5.899	100000000	937.7 MB/s
readseq	0.059081	16925774	5.908	100000000	936.2 MB/s
readrandom	0.528825	1890984	52.883	100000000	66.1 MB/s (63209188 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.438183	2282148	43.818	100000000	126.2 MB/s
compact	126478025.000000	0	126.478	1
readseq	0.047800	20920475	4.780	100000000	1157.2 MB/s
readseq	0.047111	21226451	4.711	100000000	1174.1 MB/s
readseq	0.047080	21240329	4.708	100000000	1174.9 MB/s
readrandom	0.653034	1531312	65.303	100000000	84.7 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025243	39613812	2.524	100000000	302.2 MB/s
nextwithkey	0.025279	39558166	2.528	100000000	301.8 MB/s
nextwithkey	0.025066	39893675	2.507	100000000	304.4 MB/s
readseq	0.025764	38812718	2.576	100000000	296.1 MB/s
readseq	0.025791	38771712	2.579	100000000	295.8 MB/s
readseq	0.025722	38876515	2.572	100000000	296.6 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019130	52274106	1.913	100000000	398.8 MB/s
nextwithkey	0.019052	52487073	1.905	100000000	400.4 MB/s
nextwithkey	0.019144	52234323	1.914	100000000	398.5 MB/s
readseq	0.019427	51472817	1.943	100000000	392.7 MB/s
readseq	0.019534	51192189	1.953	100000000	390.6 MB/s
readseq	0.019431	51463810	1.943	100000000	392.6 MB/s

RocksDB v8.10

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.383	723074	138.298	100000000	40.0 MB/s
compact	68681991.000	0	68.682	1
readseq	0.132	7574833	8.346	63217338	419.0 MB/s
readseq	0.096	10430494	6.061	63217338	576.9 MB/s
readseq	0.095	10485628	6.029	63217338	580.0 MB/s
readrandom	2.781	359644	278.052	100000000	12.6 MB/s (63217583 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.395	2530147	39.523	100000000	140.0 MB/s
compact	37582958.000	0	37.583	1
readseq	0.158	6333189	15.790	100000000	350.3 MB/s
readseq	0.094	10688001	9.356	100000000	591.2 MB/s
readseq	0.094	10682376	9.361	100000000	590.9 MB/s
readrandom	2.944	339697	294.379	100000000	18.8 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	255522779 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.34482 MiB/s
fillrandom	write us/op	2.55523
readrandom	Number of threads	1
readrandom	Elapsed time	310438788 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	5.22243 MiB/s
readrandom	read us/op	3.10439

RocksDB master (323d915d)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.550	645114	155.011	100000000	35.7 MB/s
compact	55660264.000	0	55.660	1
readseq	0.180	5566251	11.356	63208225	307.9 MB/s
readseq	0.132	7576402	8.343	63208225	419.1 MB/s
readseq	0.132	7589572	8.328	63208225	419.8 MB/s
readrandom	2.735	365671	273.470	100000000	12.8 MB/s (63206981 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.422	2367377	42.241	100000000	130.9 MB/s
compact	39955393.000	0	39.955	1
readseq	0.202	4945622	20.220	100000000	273.6 MB/s
readseq	0.132	7560636	13.226	100000000	418.2 MB/s
readseq	0.131	7610883	13.139	100000000	421.0 MB/s
readrandom	2.930	341345	292.958	100000000	18.9 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	262143671 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.18457 MiB/s
fillrandom	write us/op	2.62144
readrandom	Number of threads	1
readrandom	Elapsed time	316280111 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	5.12598 MiB/s
readrandom	read us/op	3.1628