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.
OpenBenchmarking.org metrics for this test profile configuration based on 1,704 public results since 24 October 2019 with the latest data as of 5 October 2024.
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.6%.
Notable instruction set extensions supported by this test, based on an automatic analysis by the Phoronix Test Suite / OpenBenchmarking.org analytics engine.
This test profile binary relies on the shared libraries libreadline.so.8, libz.so.1, libm.so.6, libc.so.6, libtinfo.so.6.
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.
1 System - 242 Benchmark Results |
2 x QEMU Virtual 2.5+ - QEMU Standard PC - 48GB Alpine Linux v3.20 3.20.2 - 6.6.44-0-virt - GCC 13.2.1 20240309 |
||||||||||||||||||
1 System - 529 Benchmark Results |
Intel Xeon Platinum 8375C - Amazon EC2 m6id.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0 |
||||||||||||||||||
1 System - 529 Benchmark Results |
Intel Xeon Platinum 8375C - Amazon EC2 m6id.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0 |
||||||||||||||||||
1 System - 529 Benchmark Results |
AMD EPYC 7R13 - Amazon EC2 m6a.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0 |
||||||||||||||||||
1 System - 529 Benchmark Results |
AMD EPYC 7R13 - Amazon EC2 m6a.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0 |
||||||||||||||||||
1 System - 529 Benchmark Results |
|
1 System - 529 Benchmark Results
|
|
1 System - 1 Benchmark Result
|
AMD Ryzen 5 3600X 6-Core - MSI B450 GAMING PRO CARBON MAX WIFI - 2 x 16384 MB 2400MHz Kingston KF3200C16D4 Microsoft Windows 10 Pro Build 19045 - 10.0.19045.3570 - 560.70
|
1 System - 115 Benchmark Results
|
AMD EPYC 7571 - Amazon EC2 m5a.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0
|
1 System - 69 Benchmark Results
|
Intel Xeon Platinum 8375C - Amazon EC2 m6id.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0
|
1 System - 21 Benchmark Results
|
AMD EPYC 9R14 - Amazon EC2 m7a.medium - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0
|
1 System - 31 Benchmark Results
|
AMD EPYC 7571 - Amazon EC2 m5a.xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0
|
1 System - 104 Benchmark Results
|
AMD EPYC 9R14 - Amazon EC2 m7a.4xlarge - Intel 440FX 82441FX PMC Ubuntu 24.04 - 6.8.0-1009-aws - GCC 13.2.0
|
3 Systems - 797 Benchmark Results
|
|
1 System - 1 Benchmark Result
|
Intel Xeon E5-2680 v4 - (GFC612NP21V10R013 BIOS) - 1 x 16384MB 2400MHz Hynix HMA42GR7AFR4N-UH Microsoft Windows Server 2022 Standard Evaluation Build 20348 - 10.0.20348.1 - 9.0.10.106 |
3 Systems - 268 Benchmark Results |
Intel Core i5-2520M - HP 161C - Intel 2nd Generation Core DRAM Ubuntu 18.04 - 4.18.0-20-generic - GNOME Shell 3.28.3 |
5 Systems - 23 Benchmark Results |
AMD Ryzen 9 5950X 16-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship Ubuntu 20.10 - 5.11.0-rc4-max-boost-inv-patch - GNOME Shell 3.38.1 |
7 Systems - 62 Benchmark Results |
Intel Core i9-7960X - MSI X299 SLI PLUS - Intel Sky Lake-E DMI3 Registers Ubuntu 18.04 - 5.0.0-32-generic - GNOME Shell 3.28.4 |
3 Systems - 30 Benchmark Results |
Intel Core i9-9900KS - ASUS PRIME Z390-A - Intel Cannon Lake PCH Alpine Linux v3.11 3.11.0 - 4.19.80-0-vanilla - X Server 1.20.6 |
Featured Disk Comparison |
AMD Ryzen 9 3950X 16-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship Ubuntu 20.04 - 5.7.0-999-generic - GNOME Shell 3.36.1 |
Featured Processor Comparison |
AMD Ryzen Threadripper 3960X 24-Core - MSI Creator TRX40 - AMD Starship Ubuntu 19.10 - 5.3.0-23-generic - GNOME Shell 3.34.1 |
Featured File-System Comparison |
AMD Ryzen 9 5900X 12-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship Ubuntu 20.04 - 5.14.0-051400rc7-generic - GNOME Shell 3.36.9 |
3 Systems - 174 Benchmark Results |
Intel Core i9-10900K - Gigabyte Z490 AORUS MASTER - Intel Comet Lake PCH Fedora 33 - 5.8.11-300.fc33.x86_64 - GNOME Shell 3.38.0 |
2 Systems - 59 Benchmark Results |
AMD Ryzen 7 3700X 8-Core - MSI MEG X570 GODLIKE - AMD Device 1480 Clear Linux OS 31480 - 5.3.8-854.native - GNOME Shell 3.34.1 |
Featured Kernel Comparison |
AMD Ryzen Threadripper 3970X 32-Core - ASUS ROG ZENITH II EXTREME - AMD Starship EndeavourOS rolling - 5.4.8-zen1-1-zen - Xfce 4.14 |
2 Systems - 90 Benchmark Results |
Intel Core i9-9900KS - ASUS PRIME Z390-A - Intel Cannon Lake PCH Ubuntu 20.04 - 5.4.0-14-generic - GNOME Shell 3.34.3 |
2 Systems - 297 Benchmark Results |
AMD Ryzen Threadripper 3990X 64-Core - System76 Thelio Major - AMD Starship Pop 20.04 - 5.4.0-7642-generic - GNOME Shell 3.36.4 |
2 Systems - 403 Benchmark Results |
Intel Core i9-10900K - Gigabyte Z490 AORUS MASTER - Intel Comet Lake PCH Ubuntu 20.10 - 5.8.0-22-generic - GNOME Shell 3.38.0 |
Featured Kernel Comparison |
AMD Ryzen 9 3900X 12-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship Ubuntu 19.10 - 5.4.0-8.2-liquorix-amd64 - GNOME Shell 3.34.1 |
7 Systems - 149 Benchmark Results |
AMD Ryzen 5 4500U - LENOVO LNVNB161216 - AMD Renoir Root Complex openSUSE 20200612 - 5.7.1-1-default - KDE Plasma 5.19.0 |