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

3 Seconds

Average Run Time

1 Minute, 2 Seconds

Accolades

30k+ Downloads

Reported Installs **Reported Test Completions **Public Result Uploads *Test Profile Page Views ***OpenBenchmarking.orgEventsSQLite Popularity Statisticssystem/sqlite2015.122016.032016.062016.092016.122017.032017.062017.092017.122018.032018.062018.092018.122019.032019.062019.092019.122020.032020.062020.092020.122021.032021.062021.092021.122022.032022.062022.092022.122023.032023.062023.092023.122024.032024.062024.095K10K15K20K25K
* 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 updated weekly as of 13 October 2024.

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.37.2

Timed SQLite Insertions

OpenBenchmarking.org metrics for this test profile configuration based on 241 public results since 13 April 2022 with the latest data as of 2 March 2023.

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

OpenBenchmarking.orgDistribution Of Public Results - Timed SQLite Insertions241 Results Range From 5 To 28 Seconds579111315171921232527294080120160200

Based on OpenBenchmarking.org data, the selected test / test configuration (SQLite 3.37.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-Time3691215Min: 1 / Avg: 1.98 / Max: 7

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

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsTimed SQLite InsertionsDeviation246810Min: 0 / Avg: 1.27 / Max: 4

Tested CPU Architectures

This benchmark has been successfully tested on the below mentioned architectures. The CPU architectures listed is where successful OpenBenchmarking.org result uploads occurred, namely for helping to determine if a given test is compatible with various alternative CPU architectures.

CPU Architecture
Kernel Identifier
Verified On
Intel / AMD x86 64-bit
x86_64
(Many Processors)

Recent Test Results

OpenBenchmarking.org Results Compare

1 System - 1 Benchmark Result

AMD Ryzen 7 7840HS - HP 8BD4 v79.46 - AMD Device 14e8

Ubuntu 24.04 - 6.9.11-x64v4-xanmod1 - KDE Plasma 5.27.11

1 System - 2 Benchmark Results

Intel Core i7-1165G7 - ASUS Zenbook UX5400EG_UX5400EG UX5400EG v1.0 - Intel Tiger Lake-LP

Ubuntu 22.04 - 6.5.0-35-generic - GNOME Shell 42.9

1 System - 2 Benchmark Results

Intel Core i7-1165G7 - ASUS Zenbook UX5400EG_UX5400EG UX5400EG v1.0 - Intel Tiger Lake-LP

Ubuntu 22.04 - 6.5.0-35-generic - GNOME Shell 42.9

1 System - 1 Benchmark Result

Intel Core i7-1165G7 - ASUS Zenbook UX5400EG_UX5400EG UX5400EG v1.0 - Intel Tiger Lake-LP

Ubuntu 22.04 - 6.5.0-35-generic - GNOME Shell 42.9

1 System - 1 Benchmark Result

2 x Intel Xeon Platinum 8269CY - Alibaba Cloud ECS - Intel Sky Lake-E DMI3 Registers

CentOS 7.6.1810 - 3.10.0-957.21.3.el7.x86_64 - GCC 4.8.5 20150623

1 System - 1 Benchmark Result

2 x Intel Xeon Platinum 8269CY - Alibaba Cloud ECS - Intel Sky Lake-E DMI3 Registers

CentOS 7.6.1810 - 3.10.0-957.21.3.el7.x86_64 - GCC 4.8.5 20150623

11 Systems - 139 Benchmark Results

2 x Intel Xeon Gold 5218 - Cisco UCSC-C480-M5 - Intel Sky Lake-E DMI3 Registers

Ubuntu 23.10 - 6.5.0-26-generic - GCC 13.2.0

12 Systems - 139 Benchmark Results

Intel Core i5-1135G7 - LENOVO Lenovo V15 G2 ITL LNVNB161216 - Intel Tiger Lake-LP

Ubuntu 23.10 - 6.5.0-9-generic - X Server 1.21.1.7

11 Systems - 139 Benchmark Results

AMD Ryzen 9 3900X 12-Core - MSI X570-A PRO - AMD Starship

Ubuntu 24.04 - 6.8.0-31-generic - GCC 13.2.0

9 Systems - 183 Benchmark Results

2 x Intel Xeon Gold 5218 - Cisco UCSC-C480-M5 - Intel Sky Lake-E DMI3 Registers

Ubuntu 23.10 - 6.5.0-9-generic - GCC 13.2.0

8 Systems - 185 Benchmark Results

AMD Ryzen 9 3900X 12-Core - MSI X570-A PRO - AMD Starship

Ubuntu 23.10 - 6.5.0-9-generic - X Server 1.21.1.7

8 Systems - 185 Benchmark Results

2 x Intel Xeon Gold 5218 - Cisco UCSC-C480-M5 - Intel Sky Lake-E DMI3 Registers

Ubuntu 23.10 - 6.5.0-26-generic - GCC 13.2.0

Find More Test Results