Result table: plain / 34809394323

← plain home | dcompact →

generated (UTC): 2026-09-14 06:56:05+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 | zipkeyonly db_bench-fillseq-cspp.yaml | zipkeyvalue db_bench-fillrandom.yaml | zipkeyvalue db_bench-fillseq.yaml | zipkeyvalue db_bench-fillseq-cspp.yaml

Runner hardware/software

OS	Ubuntu 24.04.5 LTS
Kernel	6.17.0-1022-azure
CPU	AMD EPYC 7763 64-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.80x 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.745642	1341125	74.564	100000000	74.2 MB/s
compact	44894493.000000	0	44.895	1
readseq	0.040078	24951164	4.008	100000000	1380.1 MB/s
readseq	0.040234	24854341	4.023	100000000	1374.8 MB/s
readseq	0.040137	24914567	4.014	100000000	1378.1 MB/s
readrandom	0.216826	4611993	21.683	100000000	161.2 MB/s (63202243 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.320930	3115929	32.093	100000000	172.4 MB/s
compact	40309864.000000	0	40.310	1
readseq	0.033548	29808222	3.355	100000000	1648.8 MB/s
readseq	0.033382	29955734	3.338	100000000	1656.9 MB/s
readseq	0.033861	29531837	3.386	100000000	1633.5 MB/s
readrandom	0.164506	6078791	16.451	100000000	336.2 MB/s (100000000 of 100000000 found)

db_bench (fillseq suite, CSPP)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.334547	2989110	33.455	100000000	165.3 MB/s
compact	39508030.000000	0	39.508	1
readseq	0.032859	30432719	3.286	100000000	1683.3 MB/s
readseq	0.032945	30352836	3.295	100000000	1678.9 MB/s
readseq	0.033449	29895982	3.345	100000000	1653.6 MB/s
readrandom	0.161559	6189675	16.156	100000000	342.4 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025471	39259580	2.547	100000000	299.5 MB/s
nextwithkey	0.025481	39243341	2.548	100000000	299.4 MB/s
nextwithkey	0.025593	39071947	2.559	100000000	298.1 MB/s
readseq	0.026241	38107969	2.624	100000000	290.7 MB/s
readseq	0.026241	38108115	2.624	100000000	290.7 MB/s
readseq	0.026232	38121654	2.623	100000000	290.8 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019615	50980690	1.962	100000000	389.0 MB/s
nextwithkey	0.019563	51115833	1.956	100000000	390.0 MB/s
nextwithkey	0.019704	50749519	1.970	100000000	387.2 MB/s
readseq	0.020110	49725539	2.011	100000000	379.4 MB/s
readseq	0.020002	49992950	2.000	100000000	381.4 MB/s
readseq	0.020105	49739242	2.010	100000000	379.5 MB/s

db_bench omit lazy-load (fillseq CSPP DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019779	50558059	1.978	100000000	385.7 MB/s
nextwithkey	0.019519	51230216	1.952	100000000	390.9 MB/s
nextwithkey	0.019600	51017701	1.960	100000000	389.2 MB/s
readseq	0.019963	50090689	1.996	100000000	382.2 MB/s
readseq	0.020049	49875983	2.005	100000000	380.5 MB/s
readseq	0.020084	49789019	2.008	100000000	379.9 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	279763774 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.79505 MiB/s
fillrandom	write us/op	2.79764
readrandom	Number of threads	1
readrandom	Elapsed time	350023654 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.63182 MiB/s
readrandom	read us/op	3.50024

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	34714438 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	46.7024 MiB/s
fillrandom	write us/op	0.347144
readrandom	Number of threads	1
readrandom	Elapsed time	47887578 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	33.8553 MiB/s
readrandom	read us/op	0.478876

memtablerep_bench (OffsetSkipList, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	250850179 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.46301 MiB/s
fillrandom	write us/op	2.5085
readrandom	Number of threads	1
readrandom	Elapsed time	289187108 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	5.60622 MiB/s
readrandom	read us/op	2.89187

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	0.751765	1330200	75.177	100000000	73.6 MB/s
compact	60916912.000000	0	60.917	1
readseq	0.058744	17022791	5.874	100000000	941.6 MB/s
readseq	0.058609	17062048	5.861	100000000	943.8 MB/s
readseq	0.058770	17015356	5.877	100000000	941.2 MB/s
readrandom	0.598421	1671061	59.842	100000000	58.4 MB/s (63218310 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.314733	3177277	31.473	100000000	175.7 MB/s
compact	123356832.000000	0	123.357	1
readseq	0.048103	20788443	4.810	100000000	1149.9 MB/s
readseq	0.047776	20930731	4.778	100000000	1157.7 MB/s
readseq	0.047629	20995232	4.763	100000000	1161.3 MB/s
readrandom	0.661831	1510958	66.183	100000000	83.6 MB/s (100000000 of 100000000 found)

db_bench (fillseq suite, CSPP)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.333457	2998884	33.346	100000000	165.9 MB/s
compact	123444702.000000	0	123.445	1
readseq	0.049148	20346567	4.915	100000000	1125.4 MB/s
readseq	0.048181	20754866	4.818	100000000	1148.0 MB/s
readseq	0.047893	20879668	4.789	100000000	1154.9 MB/s
readrandom	0.658202	1519290	65.820	100000000	84.0 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025554	39132234	2.555	100000000	298.6 MB/s
nextwithkey	0.025470	39261737	2.547	100000000	299.5 MB/s
nextwithkey	0.025524	39177323	2.552	100000000	298.9 MB/s
readseq	0.026089	38329684	2.609	100000000	292.4 MB/s
readseq	0.026089	38328964	2.609	100000000	292.4 MB/s
readseq	0.026232	38119765	2.623	100000000	290.8 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019550	51148775	1.955	100000000	390.2 MB/s
nextwithkey	0.019446	51424060	1.945	100000000	392.3 MB/s
nextwithkey	0.019416	51502641	1.942	100000000	392.9 MB/s
readseq	0.019993	50015604	1.999	100000000	381.6 MB/s
readseq	0.019928	50179819	1.993	100000000	382.8 MB/s
readseq	0.019938	50155154	1.994	100000000	382.7 MB/s

db_bench omit lazy-load (fillseq CSPP DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019501	51276818	1.950	100000000	391.2 MB/s
nextwithkey	0.019497	51288390	1.950	100000000	391.3 MB/s
nextwithkey	0.019593	51036812	1.959	100000000	389.4 MB/s
readseq	0.019989	50025162	1.999	100000000	381.7 MB/s
readseq	0.019998	50002875	2.000	100000000	381.5 MB/s
readseq	0.019982	50044013	1.998	100000000	381.8 MB/s

RocksDB v8.10

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.485	673484	148.482	100000000	37.3 MB/s
compact	52329766.000	0	52.330	1
readseq	0.132	7552010	8.370	63212917	417.7 MB/s
readseq	0.093	10761028	5.874	63212917	595.2 MB/s
readseq	0.093	10767154	5.871	63212917	595.6 MB/s
readrandom	2.872	348132	287.247	100000000	12.2 MB/s (63220554 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.389	2571991	38.880	100000000	142.3 MB/s
compact	37901584.000	0	37.902	1
readseq	0.153	6521572	15.334	100000000	360.7 MB/s
readseq	0.092	10819897	9.242	100000000	598.5 MB/s
readseq	0.093	10802760	9.257	100000000	597.5 MB/s
readrandom	3.169	315561	316.896	100000000	17.5 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	276644459 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.8604 MiB/s
fillrandom	write us/op	2.76644
readrandom	Number of threads	1
readrandom	Elapsed time	342871099 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.72844 MiB/s
readrandom	read us/op	3.42871

RocksDB master (7a90dc5b)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.538	650137	153.814	100000000	36.0 MB/s
compact	49999898.000	0	50.000	1
readseq	0.179	5595840	11.297	63215493	309.5 MB/s
readseq	0.134	7442301	8.494	63215493	411.7 MB/s
readseq	0.134	7439246	8.498	63215493	411.5 MB/s
readrandom	2.816	355143	281.577	100000000	12.4 MB/s (63224187 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.425	2351354	42.529	100000000	130.1 MB/s
compact	42940490.000	0	42.941	1
readseq	0.201	4981170	20.076	100000000	275.5 MB/s
readseq	0.131	7622506	13.119	100000000	421.6 MB/s
readseq	0.131	7650936	13.070	100000000	423.2 MB/s
readrandom	3.113	321211	311.321	100000000	17.8 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	302148968 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.36572 MiB/s
fillrandom	write us/op	3.02149
readrandom	Number of threads	1
readrandom	Elapsed time	352933186 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.59364 MiB/s
readrandom	read us/op	3.52933