Result table: plain / 32148249444

← plain home | dcompact →

generated (UTC): 2026-08-18 15:53:23+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 16% memory / 4.53x 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.042758	958993	104.276	100000000	53.0 MB/s
compact	32257840.000000	0	32.258	1
readseq	0.041179	24284128	4.118	100000000	1343.2 MB/s
readseq	0.040342	24787816	4.034	100000000	1371.1 MB/s
readseq	0.040432	24732695	4.043	100000000	1368.0 MB/s
readrandom	0.259742	3849959	25.974	100000000	134.6 MB/s (63204132 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.440734	2268937	44.073	100000000	125.5 MB/s
compact	41962291.000000	0	41.962	1
readseq	0.031837	31409560	3.184	100000000	1737.4 MB/s
readseq	0.031912	31335123	3.191	100000000	1733.2 MB/s
readseq	0.031844	31402261	3.184	100000000	1737.0 MB/s
readrandom	0.150632	6638665	15.063	100000000	367.2 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025137	39781219	2.514	100000000	303.5 MB/s
nextwithkey	0.024997	40003568	2.500	100000000	305.2 MB/s
nextwithkey	0.025034	39945434	2.503	100000000	304.8 MB/s
readseq	0.025712	38891756	2.571	100000000	296.7 MB/s
readseq	0.025731	38863280	2.573	100000000	296.5 MB/s
readseq	0.025801	38757256	2.580	100000000	295.7 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019057	52472614	1.906	100000000	400.3 MB/s
nextwithkey	0.019060	52463254	1.906	100000000	400.3 MB/s
nextwithkey	0.019155	52203264	1.916	100000000	398.3 MB/s
readseq	0.019470	51359063	1.947	100000000	391.8 MB/s
readseq	0.019457	51392135	1.946	100000000	392.1 MB/s
readseq	0.019453	51403098	1.945	100000000	392.2 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	305683098 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.30368 MiB/s
fillrandom	write us/op	3.05683
readrandom	Number of threads	1
readrandom	Elapsed time	394789862 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.10661 MiB/s
readrandom	read us/op	3.9479

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	37184657 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	43.5999 MiB/s
fillrandom	write us/op	0.371847
readrandom	Number of threads	1
readrandom	Elapsed time	52622742 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	30.8089 MiB/s
readrandom	read us/op	0.526227

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.069596	934932	106.960	100000000	51.7 MB/s
compact	80167781.000000	0	80.168	1
readseq	0.061245	16327570	6.125	100000000	903.1 MB/s
readseq	0.060248	16597887	6.025	100000000	918.1 MB/s
readseq	0.060326	16576375	6.033	100000000	916.9 MB/s
readrandom	0.730695	1368559	73.070	100000000	47.9 MB/s (63213729 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.444487	2249780	44.449	100000000	124.4 MB/s
compact	134317597.000000	0	134.318	1
readseq	0.048133	20775400	4.813	100000000	1149.2 MB/s
readseq	0.047261	21158956	4.726	100000000	1170.4 MB/s
readseq	0.047228	21173637	4.723	100000000	1171.2 MB/s
readrandom	0.892276	1120729	89.228	100000000	62.0 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025102	39836622	2.510	100000000	303.9 MB/s
nextwithkey	0.024965	40054393	2.497	100000000	305.6 MB/s
nextwithkey	0.024908	40145825	2.491	100000000	306.3 MB/s
readseq	0.025567	39110823	2.557	100000000	298.4 MB/s
readseq	0.025675	38947938	2.568	100000000	297.1 MB/s
readseq	0.025605	39053941	2.561	100000000	298.0 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019123	52291983	1.912	100000000	399.0 MB/s
nextwithkey	0.019014	52591747	1.901	100000000	401.2 MB/s
nextwithkey	0.019026	52560041	1.903	100000000	401.0 MB/s
readseq	0.019433	51456131	1.943	100000000	392.6 MB/s
readseq	0.019423	51482251	1.942	100000000	392.8 MB/s
readseq	0.019436	51449327	1.944	100000000	392.5 MB/s

RocksDB v8.10

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.738	575467	173.772	100000000	31.8 MB/s
compact	61355493.000	0	61.356	1
readseq	0.137	7293193	8.667	63213413	403.4 MB/s
readseq	0.096	10380365	6.090	63213413	574.2 MB/s
readseq	0.096	10394918	6.081	63213413	575.0 MB/s
readrandom	3.308	302292	330.806	100000000	10.6 MB/s (63218706 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.385	2598438	38.485	100000000	143.7 MB/s
compact	38347455.000	0	38.347	1
readseq	0.162	6190937	16.153	100000000	342.4 MB/s
readseq	0.095	10513321	9.512	100000000	581.5 MB/s
readseq	0.095	10487156	9.535	100000000	580.1 MB/s
readrandom	3.632	275302	363.237	100000000	15.2 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	330611206 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.90379 MiB/s
fillrandom	write us/op	3.30611
readrandom	Number of threads	1
readrandom	Elapsed time	383584378 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.22657 MiB/s
readrandom	read us/op	3.83584

RocksDB master (323d915d)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.649	606441	164.896	100000000	33.5 MB/s
compact	73005458.000	0	73.006	1
readseq	0.180	5551874	11.386	63213451	307.1 MB/s
readseq	0.134	7466560	8.466	63213451	413.0 MB/s
readseq	0.130	7673937	8.237	63213451	424.5 MB/s
readrandom	3.184	314096	318.373	100000000	11.0 MB/s (63212583 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.417	2400493	41.658	100000000	132.8 MB/s
compact	40083302.000	0	40.083	1
readseq	0.204	4895242	20.428	100000000	270.8 MB/s
readseq	0.133	7516581	13.304	100000000	415.8 MB/s
readseq	0.133	7507466	13.320	100000000	415.3 MB/s
readrandom	3.299	303165	329.853	100000000	16.8 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	297758047 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.44484 MiB/s
fillrandom	write us/op	2.97758
readrandom	Number of threads	1
readrandom	Elapsed time	364904089 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.44294 MiB/s
readrandom	read us/op	3.64904