SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000.

Learn more about this test at the upstream project site: http://www.sqlite.org/.

This benchmark test profile is maintained by Michael Larabel. This OpenBenchmarking.org test profile was created on 7 October 2019. To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark sqlite-speedtest.

This test has an average install time of 42 seconds and an average run-time of 6 minutes, 15 seconds.

5k+ Downloads

Installation StatsTest Completion StatsOpenBenchmarking.orgEventsSQLite Speedtest Popularitypts/sqlite-speedtest2019.102019.112019.122020.012020.022020.032020.042020.052020.062020.072020.082020.0972120168216264312

* Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting.

Revision History

pts/sqlite-speedtest-1.0.0   [View Source]   07 Oct 2019 18:39 EDT
Initial commit of SQLite speedtest1.

Suites Using This Test

C/C++ Compiler Tests

Database Test Suite

Common Kernel Benchmarks

Performance Metrics

Analyze Test Configuration:

SQLite Speedtest 3.30

Timed Time - Size 1,000

OpenBenchmarking.org metrics for this test profile configuration based on 2,232 public samples since 7 October 2019 with the latest data as of 28 October 2020.

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.

Component
Percentile Rank
Seconds (Average)
Mid-Tier
75th
> 65
Median
50th
78
30th
152
Low-Tier
25th
> 234
12th
605
OpenBenchmarking.orgDistribution Of Public Results - Timed Time - Size 1,0002232 Results Range From 43 To 7611 Seconds431953474996518039551107125914111563171518672019217123232475262727792931308332353387353936913843399541474299445146034755490750595211536355155667581959716123627564276579673168837035718773397491764330060090012001500

Based on OpenBenchmarking.org data, the selected test / test configuration (SQLite Speedtest 3.30 - Timed Time - Size 1,000) has an average run-time of 24 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 Time - Size 1,000Run-Time306090120150Min: 1 / Avg: 24 / Max: 189

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.5%.

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsTimed Time - Size 1,000Deviation246810Min: 0 / Avg: 0.46 / Max: 3

Recent Test Results

Compare

7 Systems - 74 Benchmark Results

Common KVM - QEMU Standard PC - Intel 440FX 82441FX PMC

Ubuntu 18.04 - 4.15.0-101-generic - GCC 7.5.0

14 Systems - 27 Benchmark Results

Intel Core i7-8565U - Dell 0KTW76 - Intel Cannon Point-LP

Ubuntu 20.04 - 5.4.0-31-generic - GNOME Shell 3.36.1

1 System - 295 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 - 87 Benchmark Results

ARMv8 Cortex-A53 - BCM2835 Raspberry Pi 3 Model B Plus Rev 1.3 - 913MB

Debian 10 - 5.4.51-v8+ - LXDE 0.10.0

1 System - 198 Benchmark Results

Intel Core i7-7700 - Dell 0MWYPT - Intel Xeon E3-1200 v6

MarIuX64 2.0 GNU - 5.9.0.mx64.348 - Xfce 4.14

1 System - 87 Benchmark Results

ARMv8 Cortex-A72 - BCM2835 Raspberry Pi 4 Model B Rev 1.1 - 2048MB

Debian 10 - 5.4.51-v8+ - LXDE 0.10.0

9 Systems - 57 Benchmark Results

Intel Core i5-8265U - Raticate_WL - Intel Cannon Point-LP

Ubuntu 20.04 - 5.4.0-12-generic - GNOME Shell 3.34.3

1 System - 111 Benchmark Results

Intel Core i7-1165G7 - Dell 0GG9PT - Intel Device a0ef

Ubuntu 20.04 - 5.9.0-050900-generic - GNOME Shell 3.36.4

3 Systems - 99 Benchmark Results

Intel Core i7-1165G7 - Dell 0GG9PT - Intel Device a0ef

Ubuntu 20.04 - 5.9.0-050900daily20201016-generic - GNOME Shell 3.36.4

1 System - 111 Benchmark Results

Intel Core i7-7700 - Dell 0MWYPT - Intel Xeon E3-1200 v6

MarIuX64 2.0 GNU - 5.9.0.mx64.348 - Xfce 4.14

Most Popular Test Results

Compare

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

2 Systems - 535 Benchmark Results

AMD Ryzen 5 4500U - LENOVO LNVNB161216 - AMD Renoir Root Complex

Ubuntu 20.04 - 5.9.0-050900rc7daily20201002-generic - GNOME Shell 3.36.4

4 Systems - 55 Benchmark Results

AMD Ryzen 3 3200U - MOTILE PF4PU1F - AMD Raven

Fedora 31 - 5.4.15-200.fc31.x86_64 - GNOME Shell 3.34.3

8 Systems - 360 Benchmark Results

Intel Core i9-7980XE - ASUS PRIME X299-A - Intel Sky Lake-E DMI3 Registers

Ubuntu 19.10 - 5.4.0-999-generic - GNOME Shell 3.34.1

18 Systems - 115 Benchmark Results

Intel Core i9-10980XE - Gigabyte X299X DESIGNARE 10G - Intel Sky Lake-E DMI3 Registers

Fedora 30 - 5.3.8-200.local.fc30.x86_64 - GNOME Shell 3.32.2

5 Systems - 68 Benchmark Results

AMD Ryzen 9 3900X 12-Core - MSI MPG X570 GAMING PLUS - AMD Starship

Debian testing - 5.7.10-xanmod1 - X Server 1.20.8

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

2 Systems - 736 Benchmark Results

Intel Core i5-6500 - MSI Z170-A PRO - Intel Xeon E3-1200 v5

ManjaroLinux 20.0.3 - 5.4.52-1-MANJARO - GNOME Shell 3.36.4

3 Systems - 406 Benchmark Results

Intel Core i9-10900K - Gigabyte Z490 AORUS MASTER - Intel Comet Lake PCH

Ubuntu 20.04 - 5.4.0-48-generic - GNOME Shell 3.36.4

3 Systems - 1862 Benchmark Results

Intel Core i5-6500 - MSI Z170-A PRO - Intel Xeon E3-1200 v5

ManjaroLinux 20.0.3 - 5.4.52-1-MANJARO - GNOME Shell 3.36.4

Find More Test Results


User Comments

Post A Comment