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, 14 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.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 current as of 28 September 2022.

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

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)
ARMv7 32-bit
armv7l
ARMv7 Cortex-A53 4-Core
ARMv8 64-bit
aarch64
ARMv8 Cortex-A53 4-Core, ARMv8 Cortex-A72 4-Core

Recent Test Results

OpenBenchmarking.org Results Compare

1 System - 12 Benchmark Results

2 x Intel Xeon E5-2640 0 - IBM 00Y4918 - 16 x 4096 MB Hynix HMT351V7EFR8A-H9

Microsoft Windows Server 2012 R2 Datacenter Build 9600 - 6.3.9600 - 6.3.9600.16384

1 System - 1 Benchmark Result

AMD Ryzen 5 3500U - Oracle VirtualBox v1.2 - Intel 440FX 82441FX PMC

Ubuntu 20.04 - 5.13.0-39-generic - GNOME Shell 3.36.9

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

Find More Test Results