SQLite

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

Test Created

14 December 2015

Last Updated

9 April 2018

Test Maintainer

Michael Larabel 

Test Type

Average Install Time

1 Second

Average Run Time

2 Minutes, 25 Seconds

Accolades

30k+ Downloads

Reported Installs **Reported Test Completions **Public Result Uploads *Test Profile Page Views ***OpenBenchmarking.orgEventsSQLite Popularity Statisticssystem/sqlite2015.122016.022016.042016.062016.082016.102016.122017.022017.042017.062017.082017.102017.122018.022018.042018.062018.082018.102018.122019.022019.042019.062019.082019.102019.122020.022020.042020.062020.082020.102020.122021.022021.042021.062021.082021.105K10K15K20K25K
* Uploading of benchmark result data to OpenBenchmarking.org is always optional (opt-in) via the Phoronix Test Suite for users wishing to share their results publicly.
** 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.
*** Test profile page view reporting began March 2021.
Data current as of 15 October 2021.

Revision History

system/sqlite-1.0.1   [View Source]   Mon, 09 Apr 2018 14:15:35 GMT
Fix the name for getting the SQL insertion file from pts/sqlite

system/sqlite-1.0.0   [View Source]   Mon, 14 Dec 2015 11:49:23 GMT
sqlite test


Performance Metrics

Analyze Test Configuration:

SQLite 3.27.2

Timed SQLite Insertions

OpenBenchmarking.org metrics for this test profile configuration based on 32 public results since 11 March 2019 with the latest data as of 1 November 2019.

Additional benchmark metrics will come after OpenBenchmarking.org has collected a sufficient data-set.

OpenBenchmarking.orgDistribution Of Public Results - Timed SQLite Insertions32 Results Range From 9 To 337 Seconds92745638199117135153171189207225243261279297315333351510152025

Based on OpenBenchmarking.org data, the selected test / test configuration (SQLite 3.27.2 - Timed SQLite Insertions) has an average run-time of 3 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 SQLite InsertionsRun-Time48121620Min: 1 / Avg: 2.94 / Max: 14

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

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsTimed SQLite InsertionsDeviation3691215Min: 0 / Avg: 0.96 / Max: 11

Recent Test Results

OpenBenchmarking.org Results Compare

1 System - 6 Benchmark Results

AMD Ryzen 7 4700U - LENOVO 20T6002VRI - AMD Renoir Root Complex

Slackware 14.2 x86_64 - 5.12.14-bs3 - KDE Plasma 5.22.2

5 Systems - 75 Benchmark Results

AMD Ryzen 5 PRO 4650G - ASUS TUF X470-PLUS GAMING - AMD Renoir Root Complex

Gentoo - 5.11.8-gentoo-r1 - GCC 10.2.0

2 Systems - 74 Benchmark Results

AMD Ryzen 5 PRO 4650G - ASUS TUF X470-PLUS GAMING - AMD Renoir Root Complex

Gentoo - 5.11.7-gentoo-r1 - GCC 10.2.0

1 System - 69 Benchmark Results

AMD Ryzen 5 PRO 4650G - ASUS TUF X470-PLUS GAMING - AMD Renoir Root Complex

Gentoo - 5.11.7-gentoo-r1 - GCC 10.2.0

1 System - 1 Benchmark Result

2 x Intel Xeon E5-2680 0 - Cisco UCSC-C220-M3S - Intel Xeon E5

CentOS 7.4.1708 - 3.10.0-693.2.2.el7.x86_64 - X Server

1 System - 1 Benchmark Result

2 x Intel Xeon E5-2680 0 - Cisco UCSC-C220-M3S - Intel Xeon E5

CentOS 7.4.1708 - 3.10.0-693.2.2.el7.x86_64 - X Server

1 System - 1 Benchmark Result

Intel Core i7-10700K - MSI Z490-A PRO - Intel Comet Lake PCH

Fedora 33 - 5.10.15-200.fc33.x86_64 - KDE Plasma 5.21.0

1 System - 1 Benchmark Result

Intel Core i7-10750H - 32GB - 954GB

Arch Linux - 4.4.0-19041-Microsoft - GCC 10.2.0

1 System - 1 Benchmark Result

2 x Intel Xeon Gold 6230R - Intel S2600WFT - Intel Sky Lake-E DMI3 Registers

Oracle Linux Server 8.3 - 4.18.0-193.28.1.el8_2.x86_64 - GNOME Shell 3.32.2

1 System - 1 Benchmark Result

Intel Core i7-8750H - Dell 0M2MWX - Intel Cannon Lake PCH

Fedora 32 - 5.8.4-200.fc32.x86_64 - GNOME Shell 3.36.5

1 System - 1 Benchmark Result

Intel Core i5-4690K - MSI Z97 GAMING 3 - Intel 4th Gen Core DRAM

Pop 20.04 - 5.4.0-7634-generic - GNOME Shell 3.36.2

3 Systems - 13 Benchmark Results

Intel Xeon Platinum 8175M - Amazon EC2 m5.xlarge - 16GB

CentOS Linux 7 - 3.10.0-1127.10.1.el7.x86_64 - GCC 4.8.5 20150623

2 Systems - 12 Benchmark Results

Intel Xeon Platinum 8175M - Amazon EC2 m5.xlarge - 16GB

Debian GNU - 3.10.0-1127.10.1.el7.x86_64 - GCC 8.3.0

1 System - 11 Benchmark Results

Intel Xeon Platinum 8175M - Amazon EC2 m5.xlarge - 16GB

Alpine Linux v3.12 3.12.0 - 3.10.0-1127.10.1.el7.x86_64 - GCC 9.3.0

Most Popular Test Results

OpenBenchmarking.org Results Compare

5 Systems - 8 Benchmark Results

ARMv8 Cortex-A53 - BCM2835 Raspberry Pi 3 Model B Plus Rev 1.3 - 1024MB

Raspbian 10 - 4.19.80-v8+ - GCC 8.3.0

10 Systems - 72 Benchmark Results

Intel Xeon E3-1260L v5 - ASRock E3V5 WS - Intel Xeon E3-1200 v5

Clear Linux OS 29130 - 5.0.10-742.native - GNOME Shell 3.32.1

4 Systems - 8 Benchmark Results

ARMv7 Cortex-A53 - BCM2835 Raspberry Pi 3 Model B Plus Rev 1.3 - 1024MB

Raspbian 10 - 4.19.80-v7+ - GCC 8.3.0

14 Systems - 70 Benchmark Results

Intel Xeon E3-1260L v5 - ASRock E3V5 WS - Intel Xeon E3-1200 v5

Clear Linux OS 28230 - 4.20.14-710.native - GNOME Shell 3.30.2

5 Systems - 87 Benchmark Results

Intel Core i7-8550U - Dell 0H0VG3 - Intel Xeon E3-1200 v6

Ubuntu 19.04 - 5.0.0-7-generic - GNOME Shell 3.32.0

6 Systems - 8 Benchmark Results

ARMv8 Cortex-A73 - Hardkernel ODROID-N2 - 4096MB

Debian GNU - 4.9.196+ - GCC 8.3.0

8 Systems - 8 Benchmark Results

Intel Celeron J4105 - ASRock J4105M - Intel Device 31f0

Debian 10 - 4.19.0-6-amd64 - X Server 1.20.4

3 Systems - 8 Benchmark Results

ARMv7 Cortex-A53 - BCM2835 Raspberry Pi 3 Model B Plus Rev 1.3 - 1024MB

Raspbian 10 - 4.19.80-v7+ - GCC 8.3.0

4 Systems - 87 Benchmark Results

Intel Core i9-9900K - ASUS PRIME Z390-A - Intel Cannon Lake PCH

Clear Linux OS 28460 - 5.0.3-721.native - GNOME Shell 3.32.0

2 Systems - 87 Benchmark Results

Intel Core i9-9900K - ASUS PRIME Z390-A - Intel Cannon Lake PCH

Ubuntu 18.10 - 4.18.0-16-generic - GNOME Shell 3.30.2

3 Systems - 87 Benchmark Results

Intel Core i9-9900K - ASUS PRIME Z390-A - Intel Cannon Lake PCH

Ubuntu 19.04 - 5.0.0-7-generic - GNOME Shell 3.32.0

1 System - 81 Benchmark Results

Intel Core i9-9900K - ASUS PRIME Z390-A - Intel Cannon Lake PCH

Clear Linux OS 28460 - 5.0.3-721.native - GNOME Shell 3.32.0

2 Systems - 8 Benchmark Results

ARMv7 Cortex-A53 - BCM2835 Raspberry Pi 3 Model B Plus Rev 1.3 - 1024MB

Raspbian 10 - 4.19.80-v7+ - GCC 8.3.0

1 System - 8 Benchmark Results

ARMv8 Cortex-A53 - BCM2835 Raspberry Pi 3 Model B Plus Rev 1.3 - 1024MB

Raspbian 10 - 4.19.80-v8+ - GCC 8.3.0

Find More Test Results