Result table: plain / 34722719277

← plain home | dcompact →

generated (UTC): 2026-09-13 00:02:25+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.86x 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.751061	1331449	75.106	100000000	73.6 MB/s
compact	40267735.000000	0	40.268	1
readseq	0.043133	23183691	4.313	100000000	1282.4 MB/s
readseq	0.041164	24292741	4.116	100000000	1343.7 MB/s
readseq	0.041864	23886712	4.186	100000000	1321.2 MB/s
readrandom	0.228135	4383373	22.813	100000000	153.3 MB/s (63209732 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.306794	3259483	30.680	100000000	180.3 MB/s
compact	40481921.000000	0	40.482	1
readseq	0.032305	30954462	3.231	100000000	1712.2 MB/s
readseq	0.032385	30877892	3.239	100000000	1708.0 MB/s
readseq	0.032267	30991021	3.227	100000000	1714.2 MB/s
readrandom	0.152750	6546645	15.275	100000000	362.1 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.026091	38326379	2.609	100000000	292.4 MB/s
nextwithkey	0.026075	38349645	2.608	100000000	292.6 MB/s
nextwithkey	0.026074	38350660	2.608	100000000	292.6 MB/s
readseq	0.027053	36963985	2.705	100000000	282.0 MB/s
readseq	0.027113	36881492	2.711	100000000	281.4 MB/s
readseq	0.027366	36541373	2.737	100000000	278.8 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019261	51917467	1.926	100000000	396.1 MB/s
nextwithkey	0.019210	52056003	1.921	100000000	397.2 MB/s
nextwithkey	0.019222	52022883	1.922	100000000	396.9 MB/s
readseq	0.020062	49842174	2.006	100000000	380.3 MB/s
readseq	0.019986	50033071	1.999	100000000	381.7 MB/s
readseq	0.019932	50169245	1.993	100000000	382.8 MB/s

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	367444523 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.41222 MiB/s
fillrandom	write us/op	3.67445
readrandom	Number of threads	1
readrandom	Elapsed time	421096333 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	3.85006 MiB/s
readrandom	read us/op	4.21096

memtablerep_bench (cspp, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	38121728 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	42.5281 MiB/s
fillrandom	write us/op	0.381217
readrandom	Number of threads	1
readrandom	Elapsed time	55429931 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	29.2486 MiB/s
readrandom	read us/op	0.554299

memtablerep_bench (OffsetSkipList, ToplingDB only)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	276995290 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	5.85297 MiB/s
fillrandom	write us/op	2.76995
readrandom	Number of threads	1
readrandom	Elapsed time	338859335 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.78442 MiB/s
readrandom	read us/op	3.38859

ToplingDB zipkeyvalue

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	0.726194	1377036	72.620	100000000	76.2 MB/s
compact	59697146.000000	0	59.697	1
readseq	0.059163	16902433	5.916	100000000	934.9 MB/s
readseq	0.057968	17250891	5.797	100000000	954.2 MB/s
readseq	0.058136	17200770	5.814	100000000	951.4 MB/s
readrandom	0.618149	1617730	61.815	100000000	56.6 MB/s (63203434 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.310330	3222359	31.033	100000000	178.2 MB/s
compact	125794836.000000	0	125.795	1
readseq	0.049494	20204412	4.949	100000000	1117.6 MB/s
readseq	0.048772	20503336	4.877	100000000	1134.1 MB/s
readseq	0.048507	20615283	4.851	100000000	1140.3 MB/s
readrandom	0.895949	1116134	89.595	100000000	61.7 MB/s (100000000 of 100000000 found)

db_bench omit lazy-load (fillrandom DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.026039	38403180	2.604	100000000	293.0 MB/s
nextwithkey	0.026029	38416900	2.603	100000000	293.1 MB/s
nextwithkey	0.026001	38459127	2.600	100000000	293.4 MB/s
readseq	0.026943	37114138	2.694	100000000	283.2 MB/s
readseq	0.027249	36697301	2.725	100000000	280.0 MB/s
readseq	0.027751	36033283	2.775	100000000	274.9 MB/s

db_bench omit lazy-load (fillseq DB)

benchmark	micros/op	ops/sec	seconds	operations	extra
nextwithkey	0.019253	51938878	1.925	100000000	396.3 MB/s
nextwithkey	0.019082	52405930	1.908	100000000	399.8 MB/s
nextwithkey	0.019484	51323215	1.948	100000000	391.6 MB/s
readseq	0.019932	50170252	1.993	100000000	382.8 MB/s
readseq	0.019996	50008526	2.000	100000000	381.5 MB/s
readseq	0.019932	50167987	1.993	100000000	382.8 MB/s

RocksDB v8.10

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.636	611249	163.599	100000000	33.8 MB/s
compact	39577080.000	0	39.577	1
readseq	0.146	6868708	9.203	63212933	379.9 MB/s
readseq	0.100	9965167	6.343	63212933	551.2 MB/s
readseq	0.100	9980071	6.334	63212933	552.0 MB/s
readrandom	3.001	333177	300.141	100000000	11.6 MB/s (63212299 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.358	2792440	35.811	100000000	154.5 MB/s
compact	35811754.000	0	35.812	1
readseq	0.168	5944716	16.822	100000000	328.8 MB/s
readseq	0.100	9991604	10.008	100000000	552.7 MB/s
readseq	0.100	10018596	9.981	100000000	554.2 MB/s
readrandom	3.242	308414	324.239	100000000	17.1 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	341887071 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.74205 MiB/s
fillrandom	write us/op	3.41887
readrandom	Number of threads	1
readrandom	Elapsed time	438132188 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	3.70036 MiB/s
readrandom	read us/op	4.38132

RocksDB master (7a90dc5b)

db_bench (fillrandom+compact+readseq/readrandom)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillrandom	1.732	577326	173.212	100000000	31.9 MB/s
compact	45482916.000	0	45.483	1
readseq	0.181	5515881	11.459	63208849	305.1 MB/s
readseq	0.124	8054522	7.848	63208849	445.5 MB/s
readseq	0.123	8098557	7.805	63208849	448.0 MB/s
readrandom	3.001	333235	300.088	100000000	11.6 MB/s (63204000 of 100000000 found)

db_bench (fillseq suite)

benchmark	micros/op	ops/sec	seconds	operations	extra
fillseq	0.373	2684088	37.257	100000000	148.5 MB/s
compact	38353397.000	0	38.353	1
readseq	0.200	5000516	19.998	100000000	276.6 MB/s
readseq	0.123	8146541	12.275	100000000	450.6 MB/s
readseq	0.123	8152289	12.266	100000000	450.9 MB/s
readrandom	3.202	312325	320.178	100000000	17.3 MB/s (100000000 of 100000000 found)

memtablerep_bench (skiplist)

benchmark	metric	value
fillrandom	Number of threads	1
fillrandom	Elapsed time	339787987 us
fillrandom	Total bytes written	1621.25 MiB
fillrandom	Write throughput	4.77135 MiB/s
fillrandom	write us/op	3.39788
readrandom	Number of threads	1
readrandom	Elapsed time	388770723 us
readrandom	Total bytes read	1621.25 MiB
readrandom	Read throughput	4.17019 MiB/s
readrandom	read us/op	3.88771