SQLite
This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database with a variable number of concurrent repetitions -- up to the maximum number of CPU threads available.
To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark sqlite.
Project Site
sqlite.orgSource Repository
github.comTest Created
6 December 2010Last Updated
28 April 2023Test Maintainer
Michael LarabelTest Type
DiskAverage Install Time
1 Minute, 32 SecondsAverage Run Time
7 Minutes, 18 SecondsTest Dependencies
C/C++ Compiler ToolchainAccolades
250k+ Downloads + 20k+ Public Benchmark ResultsSupported Platforms
** 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 28 November 2023.
Suites Using This Test
Performance Metrics
Analyze Test Configuration:SQLite 3.30.1
Threads / Copies: 1
OpenBenchmarking.org metrics for this test profile configuration based on 1,709 public results since 24 October 2019 with the latest data as of 20 November 2023.
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.
Based on OpenBenchmarking.org data, the selected test / test configuration (SQLite 3.30.1 - Threads / Copies: 1) has an average run-time of 6 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.
Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 2.7%.
Notable Instruction Set Usage
Notable instruction set extensions supported by this test, based on an automatic analysis by the Phoronix Test Suite / OpenBenchmarking.org analytics engine.
Found on Intel processors since Sandy Bridge (2011).
Found on AMD processors since Bulldozer (2011).
Found on Intel processors since Haswell (2013).
Found on AMD processors since Excavator (2016).
Found on Intel processors since Haswell (2013).
Found on AMD processors since Bulldozer (2011).
This test profile binary relies on the shared libraries libreadline.so.8, libz.so.1, libm.so.6, libc.so.6, libtinfo.so.6.
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.
Recent Test Results
Compare
|
1 System - 260 Benchmark Results |
Intel Xeon Platinum 8375C - Amazon EC2 m6i.4xlarge - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1049-aws - GNOME Shell 3.36.9 |
|
1 System - 251 Benchmark Results |
Intel Xeon Platinum 8358 - QEMU Standard PC - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1042-oracle - 1.1.182 |
|
1 System - 256 Benchmark Results |
AMD EPYC 7J13 64-Core - QEMU Standard PC - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1042-oracle - 1.1.182 |
|
1 System - 241 Benchmark Results |
Intel Xeon Platinum 8375C - Amazon EC2 m6i.4xlarge - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1049-aws - GNOME Shell 3.36.9 |
|
1 System - 9 Benchmark Results |
2 x Intel Xeon E5-2620 v4 - Dell PowerEdge T630 [0W9WXC] - 16 x 8192 MB 2133MHz M393A1G40EB1-CPB Microsoft Windows Server 2019 Standard Build 17763 - 10.0.17763.4974 - 10.0.17763.1 |
|
1 System - 275 Benchmark Results |
AMD EPYC 7R13 - Amazon EC2 m6a.4xlarge - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1048-aws - 1.1.182 |
|
1 System - 352 Benchmark Results |
2 x Intel Xeon Platinum 8452Y - Lenovo SB27A92818 v06 - 8 x 32 GB DDR5-4800MT AlmaLinux 9.2 - 5.14.0-284.30.1.el9_2.x86_64 - GCC 11.3.1 20221121 |
|
1 System - 58 Benchmark Results |
AMD EPYC - KVM Standard PC - 16 GB + 15616 MB RAM Fedora Linux 38 - 6.4.10-200.fc38.x86_64 - GCC 13.2.1 20230728 |
|
1 System - 32 Benchmark Results |
ARMv8 Neoverse-N1 - KVM Virtual Machine - 16 GB + 15616 MB RAM Fedora Linux 38 - 6.4.10-200.fc38.aarch64 - GCC 13.2.1 20230728 |
|
1 System - 41 Benchmark Results |
AMD Ryzen 5 3600 6-Core - MSI B450M GAMING PLUS - AMD Starship Arch rolling - 5.15.69-1-lts - KDE Plasma 5.25.5 |
|
1 System - 641 Benchmark Results |
Intel Xeon E5-2687W 0 - HP 158A - Intel Xeon E5 Ubuntu 22.04 - 5.15.0-71-generic - nouveau |