LumoSQL Benchmarking To Date

This is the first collection of results of SQLite and LumoSQL benchmarking. LumoSQL is an extended version of SQLite (not a fork) of SQLite exploring new features affecting performance, reliability, repeatability, privacy etc. The LumoSQL benchmarking tools are intended to be run by people with no connection to each other. A unique ID is assigned to each run, so they can them be combined together. Non-identifying data[*] is collected about the runtime environment for the benchmark, such as the OS and type of disk.

In this directory are SQLite databases containing the results of many runs, and also one large file with all results to date combined.

Here are our v0.6 preliminary results. We are also experimenting with R statistical methods and graphs.

We will be making this a public service at some point, however in the meantime if you have a file to add that you have generated from the instructions above please contact contact the LumoSQL team here

[*] All data is potentially identifying. It is not mandatory to collect this information, on the other hand, your biggest secret is probably not whether your disk is NVMe or SSD technology.
NameLast modifiedSizeDescription
all-lumosql-benchmark-data-combined.sqlite2022-03-28 18:45 407MCombined results of all other databases here
benchmarks-ds-dell-xeon-e2236-perc-rotational-various.sqlite2022-03-28 18:40 54M 
zZall-lumosql-benchmark-data-combined.backup2022-03-22 17:17 353MIgnore - Historical, malformed or otherwise unclean
zZbenchmark-ds-amdepyc7302p-sqlite-all-lmdb-all-datasize1,10000-2022-03-202022-03-22 17:16 24KIgnore - Historical, malformed or otherwise unclean
zZbenchmark-ds-amdepyc7302p-sqlite-all-lmdb-all-datasize1,1000-2022-03-192022-03-22 17:16 24KIgnore - Historical, malformed or otherwise unclean
benchmark-ds-amdepyc7302p-sqlite-all-datasize100,1-discard-2022-03-19.sqlite2022-03-22 17:16 4.1M 
benchmark-ds-amdepyc7302p-sqlite-all-datasize1,100-discard-2022-03-20.sqlite2022-03-22 17:16 4.1M 
benchmarks-clc-ryzen-datasize5-2022-03-19.sqlite2022-03-19 22:06 4.5M 
benchmarks-clc-ryzen-datasize2-2022-03-19.sqlite2022-03-19 16:30 4.4M 
benchmarks-clc-ryzen-datasize1-2022-03-19.sqlite2022-03-19 15:24 4.4M 
benchmark-ds-amdepyc7302pall-all-sqlite-all-lmdb-datasize1,100-2022-03-10.sqlite2022-03-13 00:19 5.0M 
benchmark-ds-amdepyc7302pall-debug-all-sqlite-all-lmdb-datasize1,1-2022-03-11.sqlite2022-03-11 12:15 24K 
benchmark-ds-amdepyc7302pall-128-sqlite-versions-datasize1,10-2022-03-10.sqlite2022-03-10 21:34 4.0M 
benchmarks-ds-skylakeibrs-datasize1-3-2022-02-17.sqlite2022-03-10 17:29 3.3M 
benchmarks-ds-i7-datasize1-3+3-1-2022-02-17.sqlite2022-03-10 17:29 13M 
zZbenchmarks-ds-i7-datasize1-3+3-1-2022-02-17.without-disk-cpu2022-03-10 17:29 13MIgnore - Historical, malformed or otherwise unclean
benchmarks-rds-AMDEPYC7302P-all-lmdb-versions-sqlite-3-34-0-0-2022-02-07.sqlite2022-03-10 16:57 76M 
benchmarks-ds-skylakeibrs-datasize6-100-2022-02-28.sqlite2022-03-10 16:56 8.2M 
benchmarks-clc-datasize5-2022-02-07.sqlite2022-03-10 16:48 356K 
benchmarks-clc-datasize1-2022-02-07.sqlite2022-03-10 16:47 7.6M 
benchmarks-clc-2022-02-06.sqlite2022-03-10 16:47 9.9M 
benchmarks-clc-2022-02-05.sqlite2022-03-10 16:47 3.4M 
zZbenchmarks-clc-i3-datasize1-2022-02-16-a.without-disk-cpu2022-03-10 15:55 288KIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-i3-datasize1-2022-02-13.without-disk-cpu2022-03-10 15:55 19MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-i3-datasize1,2-2022-02-14.without-disk-cpu2022-03-10 15:55 19MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-datasize4-2022-02-07.without-disk-cpu2022-03-10 15:55 7.5MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-datasize2-2022-02-08.without-disk-cpu2022-03-10 15:55 7.5MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-datasize2-2022-02-07.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-datasize1-2022-02-08.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-a1-datasize4-2022-02-10.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-a1-datasize2-2022-02-09.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-a-datasize4-2022-02-09.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-a-datasize2-2022-02-08.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-a-datasize1-2022-02-08.without-disk-cpu2022-03-10 15:55 7.6MIgnore - Historical, malformed or otherwise unclean
benchmarks-ds-amdepyc7302p-all-128-sqlite-versions-datasize5,1-2022-03-07.sqlite2022-03-10 01:56 4.0M 
benchmarks-ds-amdepyc7302p-all-128-sqlite-versions-datasize1,5-2022-03-08.sqlite2022-03-10 01:56 4.0M 
benchmarks-ds-amdepyc7302p-all-128-sqlite-versions-datasize1,1-2022-03-07.sqlite2022-03-10 01:56 4.0M 
benchmarks-ds-amdepyc7302p-all-128-sqlite-versions-datasize10,1-2022-03-08.sqlite2022-03-10 01:56 4.0M 
zZbenchmarks-ds-skylakeibrs-datasize1-3-2022-02-17.without-disk-cpu2022-03-07 13:52 3.3MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-datasize1-2022-02-07.without-disk-cpu2022-03-04 14:44 7.6MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-2022-02-06.without-disk-cpu2022-03-04 14:44 9.8MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-2022-02-05.without-disk-cpu2022-03-04 14:44 3.4MIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-clc-datasize5-2022-02-07.without-disk-cpu2022-03-04 14:43 352KIgnore - Historical, malformed or otherwise unclean
zZbenchmarks-ds-skylakeibrs-datasize6-100-2022-02-28.without-disk-cpu2022-02-28 03:17 8.1MIgnore - Historical, malformed or otherwise unclean
benchmarks-clc-i5-datasize5-2022-02-17.sqlite2022-02-18 01:05 6.6M 
benchmarks-clc-i5-datasize5,1-2022-02-17.sqlite2022-02-17 06:51 6.6M 
benchmarks-clc-i5-datasize1,5-2022-02-16.sqlite2022-02-17 02:14 6.6M 
benchmarks-clc-i5-datasize1-2022-02-16.sqlite2022-02-16 23:23 6.5M 
benchmarks-clc-i3-datasize1-2022-02-16-a.sqlite2022-02-16 12:33 288K 
benchmarks-clc-ryzen-datasize1-2022-02-16-a.sqlite2022-02-16 12:18 288K 
benchmarks-clc-i3-datasize1-2022-02-16.sqlite2022-02-16 12:18 6.6M 
benchmarks-clc-ryzen-datasize1-2022-02-16.sqlite2022-02-16 12:12 6.5M 
zZall-lumosql-benchmark-data-combined.historical2022-02-15 17:40 248MIgnore - Historical, malformed or otherwise unclean
benchmarks-clc-i3-datasize2,1-2022-02-14.sqlite2022-02-15 07:14 20M 
benchmarks-clc-i3-datasize1,2-2022-02-14.sqlite2022-02-14 21:46 19M 
benchmarks-clc-i3-datasize2-2022-02-13.sqlite2022-02-14 12:13 19M 
benchmarks-clc-i3-datasize1-2022-02-13.sqlite2022-02-13 21:09 19M 
benchmarks-datasizes-2022-02-11.sqlite2022-02-11 10:32 280K 
benchmarks-clc-pi-misc-2022-02-10.sqlite2022-02-10 19:30 276K 
benchmarks-clc-pi-datasize1-2022-02-10.sqlite2022-02-10 17:33 656K 
benchmarks-clc-a1-datasize4-2022-02-10.sqlite2022-02-10 15:25 7.6M 
benchmarks-clc-a-datasize4-2022-02-09.sqlite2022-02-09 22:38 7.6M 
benchmarks-clc-a1-datasize2-2022-02-09.sqlite2022-02-09 05:05 7.6M 
benchmarks-clc-datasize2-2022-02-08.sqlite2022-02-09 03:18 7.5M 
benchmarks-clc-datasize1-2022-02-08.sqlite2022-02-08 23:45 7.6M 
benchmarks-clc-a-datasize2-2022-02-08.sqlite2022-02-08 23:11 7.6M 
benchmarks-clc-a-datasize1-2022-02-08.sqlite2022-02-08 19:04 7.6M 
benchmarks-clc-datasize4-2022-02-07.sqlite2022-02-08 14:56 7.5M 
benchmarks-clc-datasize2-2022-02-07.sqlite2022-02-08 02:52 7.6M 
zZbenchmarks.Uilebheist.20201228-hdd-1.historical2022-02-07 22:41 116KIgnore - Historical, malformed or otherwise unclean
zZbenchmarks.Uilebheist.20201228-5.historical2022-02-07 22:41 500KIgnore - Historical, malformed or otherwise unclean
zZbenchmarks.Uilebheist.20201228-2.historical2022-02-07 22:41 492KIgnore - Historical, malformed or otherwise unclean
zZbenchmarks.Uilebheist.20201228-1.historical2022-02-07 22:41 492KIgnore - Historical, malformed or otherwise unclean
zZbenchmarks.Uilebheist.20201112.historical2022-02-07 22:41 340KIgnore - Historical, malformed or otherwise unclean
zZbenchmark2.historical2022-02-07 22:41 24KIgnore - Historical, malformed or otherwise unclean
zZbenchmark1.historical2022-02-07 22:41 24KIgnore - Historical, malformed or otherwise unclean
zZbench3.historical2022-02-07 12:50 3.3MIgnore - Historical, malformed or otherwise unclean
zZbench2.historical2022-02-07 12:50 232KIgnore - Historical, malformed or otherwise unclean
zZbench1.historical2022-02-07 12:50 272KIgnore - Historical, malformed or otherwise unclean

Apache/2.4.52 (Debian) Server at lumosql.org Port 443