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

2 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.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 23 November 2023.

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 7700 8-Core - ASRock A620M-HDV/M.2+ - AMD Device 14d8

Debian 12 - 6.1.0-11-amd64 - GNOME Shell 43.6

1 System - 1 Benchmark Result

Intel Xeon Gold 6148 - Tencent Cloud CVM v3.0 - Intel 440FX 82441FX PMC

Ubuntu 22.04 - 5.15.0-56-generic - 1.3.224

1 System - 54 Benchmark Results

Intel Core i7-8700 - ASUS PRIME Z370-A II - Intel 8th Gen Core

Arch Linux - 6.2.13-508-kb - X Server 1.21.1.8

1 System - 54 Benchmark Results

Intel Core i7-8700 - ASUS PRIME Z370-A II - Intel 8th Gen Core

Arch Linux - 6.2.13-501-kb - X Server 1.21.1.8

1 System - 62 Benchmark Results

AMD Ryzen 9 7950X 16-Core - ASUS TUF GAMING B650-PLUS - AMD Device 14d8

Arch Linux - 6.2.13-576-kb - X Server

1 System - 54 Benchmark Results

Intel Core i7-8700 - ASUS PRIME Z370-A II - Intel 8th Gen Core

Arch Linux - 6.2.13-400-kb - X Server 1.21.1.8

1 System - 62 Benchmark Results

AMD Ryzen 9 7950X 16-Core - ASUS TUF GAMING B650-PLUS - AMD Device 14d8

Arch Linux - 6.2.13-400-kb - X Server

1 System - 54 Benchmark Results

Intel Core i7-8700 - ASUS PRIME Z370-A II - Intel 8th Gen Core

Arch Linux - 6.2.13-400-kb - X Server 1.21.1.8

1 System - 1 Benchmark Result

2 x Intel Xeon E5-2665 0 - HP ProLiant DL380p Gen8 - Intel Xeon E5

Debian GNU - 5.15.107-2-pve - 1.0.2

1 System - 62 Benchmark Results

AMD Ryzen 9 7950X 16-Core - ASUS TUF GAMING B650-PLUS - AMD Device 14d8

Arch Linux - 6.2.13-400-kb - X Server

1 System - 37 Benchmark Results

ARMv8 Neoverse-N1 - KVM Virtual Machine - 1 x 16000 MB RAM QEMU

Debian 12 - 6.1.0-7-arm64 - GCC 12.2.0

1 System - 39 Benchmark Results

ARMv8 Neoverse-N1 - KVM Virtual Machine - 1 x 4000 MB RAM QEMU

Debian 12 - 6.1.0-9-arm64 - GCC 12.2.0

1 System - 40 Benchmark Results

ARMv8 Neoverse-N1 - KVM Virtual Machine - 1 x 8000 MB RAM QEMU

Debian 12 - 6.1.0-9-arm64 - GCC 12.2.0

1 System - 50 Benchmark Results

ARMv8 Neoverse-N1 - KVM Virtual Machine - 1 x 4000 MB RAM QEMU

Debian 12 - 6.1.0-9-arm64 - GCC 12.2.0

1 System - 62 Benchmark Results

Intel Core i7-8700 - ASUS PRIME Z370-A II - Intel 8th Gen Core

Arch Linux - 6.2.13-400-kb - X Server 1.21.1.8

Most Popular Test Results

OpenBenchmarking.org Results Compare

2 Systems - 31 Benchmark Results

Intel Xeon E5-2470 v2 - Dell 0W7H8C - Intel Xeon E7 v2

Ubuntu 22.04 - 5.15.0-25-generic - GNOME Shell 42.0

3 Systems - 30 Benchmark Results

2 x Intel Xeon E5-2470 v2 - QEMU Standard PC - Intel 82G33

Ubuntu 22.04 - 5.15.0-25-generic - 1.2.204

1 System - 30 Benchmark Results

Intel Xeon E5-2470 v2 - Dell 0W7H8C - Intel Xeon E7 v2

Ubuntu 22.04 - 5.15.0-25-generic - GNOME Shell 42.0

1 System - 30 Benchmark Results

Intel Xeon E5-2470 v2 - Dell 0W7H8C - Intel Xeon E7 v2

Ubuntu 22.04 - 5.15.0-25-generic - GNOME Shell 42.0

1 System - 1 Benchmark Result

AMD A10-7850K Radeon R7 12 Compute Cores 4C+8G - Gigabyte F2A88X-D3H - AMD 15h

Ubuntu 22.04 - 5.15.0-58-generic - MATE 1.26.0
Find More Test Results