SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000.

To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark sqlite-speedtest.

Project Site

sqlite.org

Test Created

7 October 2019

Last Updated

11 December 2020

Test Maintainer

Michael Larabel

Test Type

System

Average Install Time

41 Seconds

Average Run Time

6 Minutes, 19 Seconds

Accolades

5k+ Downloads

Supported Platforms


Public Result UploadsReported Installs*Test Completions*OpenBenchmarking.orgEventsSQLite Speedtest Popularity Statisticspts/sqlite-speedtest2019.102019.112019.122020.012020.022020.032020.042020.052020.062020.072020.082020.092020.102020.112020.122021.0110002000300040005000
* Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting while running benchmarks from an Internet-connected platform.
Data current as of Thu, 21 Jan 2021 22:19:13 GMT.

Revision History

pts/sqlite-speedtest-1.0.1   [View Source]   Fri, 11 Dec 2020 17:29:10 GMT
BSD build update.

pts/sqlite-speedtest-1.0.0   [View Source]   Mon, 07 Oct 2019 18:39:59 GMT
Initial commit of SQLite speedtest1.

Suites Using This Test

C/C++ Compiler Tests

Database Test Suite

Common Kernel Benchmarks

Server

Programmer / Developer System Benchmarks


Performance Metrics

Analyze Test Configuration:

SQLite Speedtest 3.30

Timed Time - Size 1,000

OpenBenchmarking.org metrics for this test profile configuration based on 2,228 public results since 7 October 2019 with the latest data as of 22 January 2021.

Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.

Component
Percentile Rank
# Matching Public Results
Seconds (Average)
96th
41
47 +/- 2
94th
16
48 +/- 1
94th
5
48 +/- 1
94th
22
50 +/- 3
89th
7
55 +/- 6
89th
4
55 +/- 2
87th
55
56 +/- 2
86th
49
57 +/- 9
85th
12
57 +/- 1
80th
5
58 +/- 6
77th
12
60 +/- 12
76th
23
61 +/- 6
76th
3
61 +/- 1
Mid-Tier
75th
> 62
74th
26
63 +/- 3
73rd
9
64 +/- 1
73rd
23
64 +/- 2
70th
12
65 +/- 4
66th
10
66 +/- 6
63rd
11
67 +/- 2
62nd
4
68 +/- 1
62nd
6
68 +/- 3
58th
4
70 +/- 1
58th
7
70 +/- 2
56th
14
71 +/- 1
56th
15
71 +/- 2
56th
8
71 +/- 2
55th
26
72 +/- 2
51st
17
74 +/- 2
51st
7
74 +/- 6
Median
50th
74
49th
4
75 +/- 3
49th
12
75 +/- 8
46th
6
76 +/- 7
43rd
4
77 +/- 2
43rd
9
77 +/- 5
41st
24
78 +/- 1
41st
15
78 +/- 2
41st
19
78 +/- 2
41st
6
78 +/- 2
41st
12
78 +/- 3
38th
7
79 +/- 1
38th
7
79 +/- 1
33rd
6
82 +/- 1
32nd
6
83 +/- 1
31st
15
85 +/- 2
28th
19
92 +/- 8
28th
20
92 +/- 11
27th
13
94 +/- 4
Low-Tier
25th
> 96
25th
7
96 +/- 1
24th
4
98 +/- 3
22nd
6
105 +/- 7
22nd
9
109 +/- 5
21st
41
111 +/- 31
20th
12
117 +/- 1
19th
7
125 +/- 15
17th
7
141 +/- 4
17th
5
143 +/- 5
17th
3
145 +/- 1
16th
3
158 +/- 25
15th
9
165 +/- 2
15th
15
170 +/- 1
8th
20
335 +/- 2
6th
8
477 +/- 24
5th
4
613 +/- 27
OpenBenchmarking.orgDistribution Of Public Results - Timed Time - Size 1,0002228 Results Range From 40 To 7611 Seconds4019234449664880095211041256140815601712186420162168232024722624277629283080323233843536368838403992414442964448460047524904505652085360551256645816596861206272642465766728688070327184733674887640400800120016002000

Based on OpenBenchmarking.org data, the selected test / test configuration (SQLite Speedtest 3.30 - Timed Time - Size 1,000) has an average run-time of 7 minutes. By default this test profile is set to run at least 3 times but may increase if the standard deviation exceeds pre-defined defaults or other calculations deem additional runs necessary for greater statistical accuracy of the result.

OpenBenchmarking.orgMinutesTime Required To Complete BenchmarkTimed Time - Size 1,000Run-Time20406080100Min: 1 / Avg: 6.48 / Max: 120

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.4%.

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsTimed Time - Size 1,000Deviation246810Min: 0 / Avg: 0.39 / Max: 4

Recent Test Results

OpenBenchmarking.org Results Compare

4 Systems - 14 Benchmark Results

Intel Core i5-7200U - Dell 0XT0D3 - Intel Xeon E3-1200 v6

Debian 10 - 4.19.0-13-amd64 - GNOME Shell 3.30.2

1 System - 14 Benchmark Results

Intel Core i7-4870HQ - Apple MacBook Pro - Apple SSD

macOS 10.15.7 - 19.6.0 - X Server 1.18.4

2 Systems - 129 Benchmark Results

AMD Ryzen 9 5950X 16-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 20.10 - 5.11.0-051100rc2daily20210108-generic - GNOME Shell 3.38.1

3 Systems - 191 Benchmark Results

AMD Ryzen 3 2200G - ASUS PRIME B350M-E - AMD Raven

Ubuntu 20.10 - 5.8.0-38-generic - GNOME Shell 3.38.1

3 Systems - 125 Benchmark Results

AMD Ryzen 9 5950X 16-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 20.10 - 5.11.0-051100rc2daily20210108-generic - GNOME Shell 3.38.1

4 Systems - 104 Benchmark Results

AMD Ryzen 5 2400G - MSI B350M GAMING PRO - AMD Raven

Ubuntu 19.10 - 5.3.0-64-generic - GNOME Shell 3.34.1

4 Systems - 42 Benchmark Results

ARMv8 Cortex-A72 - Helios64 - Fuzhou Rockchip RK3399

Debian 10 - 5.9.14-rockchip64 - GCC 8.3.0

1 System - 1 Benchmark Result

Intel Core i9-10885H - Dell 0XWT2F - Intel Comet Lake PCH

Arch rolling - 5.10.6-arch1-1 - X Server 1.20.10

3 Systems - 53 Benchmark Results

ARMv8 Cortex-A72 - BCM2835 Raspberry Pi 400 Rev 1.0 - 4096MB

Debian 10 - 5.4.51-v8+ - LXDE 0.10.0

8 Systems - 69 Benchmark Results

Intel Core i9-7980XE - ASUS PRIME X299-A - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.3.0-24-generic - GNOME Shell 3.34.1

1 System - 34 Benchmark Results

6 x Intel Xeon E5-2667 v4 - Virtuozzo KVM - Intel 440FX- 82441FX PMC

Ubuntu 18.04 - 4.15.0-130-generic - ext4

Most Popular Test Results

OpenBenchmarking.org Results Compare

3 Systems - 268 Benchmark Results

Intel Core i5-2520M - HP 161C - Intel 2nd Generation Core DRAM

Ubuntu 18.04 - 4.18.0-20-generic - GNOME Shell 3.28.3

2 Systems - 535 Benchmark Results

AMD Ryzen 5 4500U - LENOVO LNVNB161216 - AMD Renoir Root Complex

Ubuntu 20.04 - 5.9.0-050900rc7daily20201002-generic - GNOME Shell 3.36.4

11 Systems - 217 Benchmark Results

AMD Ryzen 7 3800XT 8-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 20.04 - 5.9.0-050900-generic - GNOME Shell 3.36.4

4 Systems - 55 Benchmark Results

AMD Ryzen 3 3200U - MOTILE PF4PU1F - AMD Raven

Ubuntu 20.04 - 5.4.0-9-generic - GNOME Shell 3.34.3

4 Systems - 99 Benchmark Results

Apple - Apple Mac mini - 8GB

macOS 11.0 - 20.1.0 - OpenCL 1.2

8 Systems - 360 Benchmark Results

Intel Core i9-7980XE - ASUS PRIME X299-A - Intel Sky Lake-E DMI3 Registers

Ubuntu 19.10 - 5.4.0-999-generic - GNOME Shell 3.34.1

3 Systems - 174 Benchmark Results

Intel Core i9-10900K - Gigabyte Z490 AORUS MASTER - Intel Comet Lake PCH

Fedora 33 - 5.8.11-300.fc33.x86_64 - GNOME Shell 3.38.0

18 Systems - 115 Benchmark Results

AMD Ryzen 9 3900X 12-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 19.10 - 5.3.0-17-generic - GNOME Shell 3.34.1

2 Systems - 403 Benchmark Results

Intel Core i9-10900K - Gigabyte Z490 AORUS MASTER - Intel Comet Lake PCH

Ubuntu 20.04 - 5.4.0-48-generic - GNOME Shell 3.36.4

3 Systems - 406 Benchmark Results

Intel Core i9-10900K - Gigabyte Z490 AORUS MASTER - Intel Comet Lake PCH

Ubuntu 20.04 - 5.4.0-48-generic - GNOME Shell 3.36.4

Find More Test Results

OpenBenchmarking.org Community User Comments

Post A Comment