Result table: plain / 34698861539

← plain home | dcompact →

generated (UTC): 2026-09-12 15:43:43+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 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 / 5.10x 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.777988	1285365	77.799	100000000	71.1 MB/s
compact	42837919.000000	0	42.838	1
readseq	0.044781	22330724	4.478	100000000	1235.2 MB/s
readseq	0.044276	22585242	4.428	100000000	1249.3 MB/s
readseq	0.044757	22342554	4.476	100000000	1235.8 MB/s
readrandom	0.238060	4200619	23.806	100000000	146.9 MB/s (63213728 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.334603	2988610	33.460	100000000	165.3 MB/s
compact	40803861.000000	0	40.804	1
readseq	0.032503	30766504	3.250	100000000	1701.8 MB/s
readseq	0.032958	30341610	3.296	100000000	1678.3 MB/s
readseq	0.032955	30344206	3.296	100000000	1678.4 MB/s
readrandom	0.164390	6083062	16.439	100000000	336.5 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025073	39883715	2.507	100000000	304.3 MB/s
nextwithkey	0.025111	39822994	2.511	100000000	303.8 MB/s
nextwithkey	0.025127	39796211	2.513	100000000	303.6 MB/s
readseq	0.025648	38987889	2.565	100000000	297.5 MB/s
readseq	0.025645	38993636	2.565	100000000	297.5 MB/s
readseq	0.025809	38744447	2.581	100000000	295.6 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019069	52438604	1.907	100000000	400.1 MB/s
nextwithkey	0.019053	52484153	1.905	100000000	400.4 MB/s
nextwithkey	0.019213	52046846	1.921	100000000	397.1 MB/s
readseq	0.019457	51393588	1.946	100000000	392.1 MB/s
readseq	0.019460	51386458	1.946	100000000	392.0 MB/s
readseq	0.019448	51416736	1.945	100000000	392.3 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	275557133 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.88352 MiB/s
fillrandom	write us/op	2.75557
readrandom	Number of threads	1
readrandom	Elapsed time	361780224 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.4813 MiB/s
readrandom	read us/op	3.6178

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	33347503 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	48.6167 MiB/s
fillrandom	write us/op	0.333475
readrandom	Number of threads	1
readrandom	Elapsed time	44878410 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	36.1253 MiB/s
readrandom	read us/op	0.448784

memtablerep_bench (OffsetSkipList, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	251640736 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.4427 MiB/s
fillrandom	write us/op	2.51641
readrandom	Number of threads	1
readrandom	Elapsed time	264085108 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	6.13911 MiB/s
readrandom	read us/op	2.64085

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	0.724703	1379874	72.470	100000000	76.3 MB/s
compact	63604525.000000	0	63.605	1
readseq	0.059216	16887119	5.922	100000000	934.1 MB/s
readseq	0.059605	16776935	5.961	100000000	928.0 MB/s
readseq	0.059262	16874097	5.926	100000000	933.4 MB/s
readrandom	0.562311	1778374	56.231	100000000	62.2 MB/s (63211377 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.340314	2938439	34.032	100000000	162.5 MB/s
compact	123973352.000000	0	123.973	1
readseq	0.047832	20906204	4.783	100000000	1156.4 MB/s
readseq	0.047170	21199843	4.717	100000000	1172.6 MB/s
readseq	0.046991	21280457	4.699	100000000	1177.1 MB/s
readrandom	0.714675	1399236	71.468	100000000	77.4 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.025046	39925738	2.505	100000000	304.6 MB/s
nextwithkey	0.024985	40023053	2.499	100000000	305.4 MB/s
nextwithkey	0.025198	39685075	2.520	100000000	302.8 MB/s
readseq	0.025681	38938459	2.568	100000000	297.1 MB/s
readseq	0.025766	38809615	2.577	100000000	296.1 MB/s
readseq	0.025750	38834182	2.575	100000000	296.3 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019000	52631080	1.900	100000000	401.5 MB/s
nextwithkey	0.018971	52709366	1.897	100000000	402.1 MB/s
nextwithkey	0.019113	52319890	1.911	100000000	399.2 MB/s
readseq	0.019453	51404605	1.945	100000000	392.2 MB/s
readseq	0.019455	51398422	1.946	100000000	392.1 MB/s
readseq	0.019436	51448215	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.434	697158	143.439	100000000	38.6 MB/s
compact	64530047.000	0	64.530	1
readseq	0.133	7540211	8.383	63207523	417.1 MB/s
readseq	0.092	10818630	5.842	63207523	598.4 MB/s
readseq	0.092	10820626	5.841	63207523	598.5 MB/s
readrandom	2.869	348512	286.934	100000000	12.2 MB/s (63218827 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.399	2504963	39.921	100000000	138.6 MB/s
compact	37610484.000	0	37.611	1
readseq	0.155	6457506	15.486	100000000	357.2 MB/s
readseq	0.093	10793220	9.265	100000000	597.0 MB/s
readseq	0.093	10761826	9.292	100000000	595.3 MB/s
readrandom	3.173	315115	317.344	100000000	17.4 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	267559322 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.05939 MiB/s
fillrandom	write us/op	2.67559
readrandom	Number of threads	1
readrandom	Elapsed time	331910921 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.88458 MiB/s
readrandom	read us/op	3.31911

RocksDB master (7a90dc5b)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.603	623994	160.258	100000000	34.5 MB/s
compact	53592017.000	0	53.592	1
readseq	0.178	5622397	11.243	63212967	311.0 MB/s
readseq	0.129	7729886	8.178	63212967	427.6 MB/s
readseq	0.129	7773380	8.132	63212967	430.0 MB/s
readrandom	2.930	341340	292.963	100000000	11.9 MB/s (63211116 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.414	2417268	41.369	100000000	133.7 MB/s
compact	42554317.000	0	42.554	1
readseq	0.204	4912354	20.357	100000000	271.7 MB/s
readseq	0.131	7624690	13.115	100000000	421.7 MB/s
readseq	0.131	7606664	13.146	100000000	420.7 MB/s
readrandom	2.788	358705	278.781	100000000	19.8 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	267808547 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	6.05375 MiB/s
fillrandom	write us/op	2.67809
readrandom	Number of threads	1
readrandom	Elapsed time	311668210 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	5.20183 MiB/s
readrandom	read us/op	3.11668