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 25 December 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.
3 Systems - 33 Benchmark Results |
Apple M1 Pro - Apple MacBook Pro - 32GB macOS 12.6.1 - 21.6.0 - GCC 14.0.0 + Clang 14.0.0 + Xcode 14.1 |
||||||||||
2 Systems - 32 Benchmark Results |
Apple M4 Max - Apple MacBook Pro - 48GB macOS 15.1.1 - 24.1.0 - X Server |
||||||||||
1 System - 1 Benchmark Result |
2 x Intel Xeon Gold 6230 - QEMU Standard PC - Intel 82G33 Ubuntu 24.04 - 6.8.0-45-generic - GCC 13.2.0 |
||||||||||
1 System - 143 Benchmark Results |
Apple M4 Max - Apple MacBook Pro - 128GB macOS 15.1 - 24.1.0 - GCC 16.0.0 + Clang 16.0.0 |
||||||||||
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 |
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 |
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 |
7 Systems - 62 Benchmark Results |
Intel Core i9-7960X - 16384MB - 238GB Ubuntu 18.04 - 4.4.0-19008-Microsoft - GCC 7.4.0 |
3 Systems - 30 Benchmark Results |
Intel Core i9-9900KS - ASUS PRIME Z390-A - Intel Cannon Lake PCH Clear Linux OS 31950 - 5.4.4-880.native - GNOME Shell 3.34.2 |
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 - 269 Benchmark Results |
AMD Ryzen Threadripper 3990X 64-Core - System76 Thelio Major - AMD Starship Pop 20.04 - 5.4.0-7626-generic - GNOME Shell 3.36.1 |
2 Systems - 59 Benchmark Results |
AMD Ryzen 7 3700X 8-Core - MSI MEG X570 GODLIKE - AMD Device 1480 Clear Linux OS 31470 - 5.3.8-854.native - GNOME Shell 3.34.1 |
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 |
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 - 297 Benchmark Results |
AMD Ryzen Threadripper 3990X 64-Core - System76 Thelio Major - AMD Starship Pop 20.10 - 5.8.0-7625-generic - GNOME Shell 3.38.1 |
7 Systems - 149 Benchmark Results |
AMD Ryzen 5 4500U - LENOVO LNVNB161216 - AMD Renoir Root Complex Ubuntu 20.10 - 5.7.4-050704-generic - GNOME Shell 3.36.3 |
Featured Kernel Comparison |
AMD Ryzen 9 3900X 12-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship Ubuntu 19.10 - 5.4.0-7.1-liquorix-amd64 - GNOME Shell 3.34.1 |