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.

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

This benchmark test is maintained by Michael Larabel. This OpenBenchmarking.org test profile was created on 6 December 2010 and last updated on 24 October 2019. To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark sqlite.

This test has an average install time of 1 minute, 7 seconds and an average run-time of 29 minutes, 16 seconds.

200k+ Downloads

Performance Metrics

Analyze Test Configuration:

SQLite 3.30.1

Threads / Copies: 32

OpenBenchmarking.org metrics for this test profile configuration based on 1,551 public samples since 24 October 2019 with the latest data as of 15 September 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.

OpenBenchmarking.orgDistribution Of Public Results1551 Results Range From 7 To 7378 Seconds715530345159974789510431191133914871635178319312079222723752523267128192967311532633411355937073855400341514299444745954743489150395187533554835631577959276075622363716519666768156963711172597407110220330440550

Revision History

pts/sqlite-2.1.0     24 Oct 2019 12:31 EDT
Update based on https://github.com/phoronix-test-suite/test-profiles/pull/108 plus fixes, update against SQLite 3.30.1 upstream.

pts/sqlite-2.0.1     28 Feb 2018 10:14 EST
Add Windows support.

pts/sqlite-2.0.0     26 Feb 2018 17:18 EST
Update against SQLite 3.22.

pts/sqlite-1.9.0     09 Jun 2015 21:45 EDT
Big update to SQLite

pts/sqlite-1.8.0     06 Dec 2010 15:22 EST
Initial import into OpenBenchmarking.org

Recent Test Results

Compare

3 Systems - 8 Benchmark Results

Intel Core 2 Duo P7350 - MSI MS-1722 - Intel Mobile 4 MCH + ICH9M

Ubuntu 20.04 - 5.4.0-47-generic - X Server 1.20.8

17 Systems - 14 Benchmark Results

Intel Core i7-3615QM - Apple Mac-C3EC7CD22292981F - Intel 3rd Gen Core DRAM

Gentoo 2.6 - 5.6.4-gentoo-x86_64 - LXQt 0.14.1

2 Systems - 8 Benchmark Results

Intel Core 2 Duo P7350 - MSI MS-1722 - Intel Mobile 4 MCH + ICH9M

OpenMandrivaLinux 4.1 - 5.5.12-desktop-1omv4001 - KDE Plasma 5.17.5

1 System - 27 Benchmark Results

AMD Ryzen 3 2200G - ASRock A320M-ITX - AMD Raven

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

38 Systems - 13 Benchmark Results

Intel Core i7-3615QM - Apple Mac-C3EC7CD22292981F - Intel 3rd Gen Core DRAM

Gentoo 2.6 - 5.8.0-gentoo-r1-x86_64clang - MATE 1.24.0

1 System - 10 Benchmark Results

Intel Core 2 Duo P7350 - MSI MS-1722 - Intel Mobile 4 MCH + ICH9M

OpenMandrivaLinux 4.1 - 5.5.12-desktop-1omv4001 - KDE Plasma 5.17.5

1 System - 8 Benchmark Results

Intel Core 2 Duo P7350 - MSI MS-1722 - Intel Mobile 4 MCH + ICH9M

OpenMandrivaLinux 4.1 - 5.5.12-desktop-1omv4001 - KDE Plasma 5.17.5

16 Systems - 14 Benchmark Results

Intel Core i7-3615QM - Apple Mac-C3EC7CD22292981F - Intel 3rd Gen Core DRAM

Gentoo 2.6 - 4.19.128-gentoo-x86_64 - MATE 1.24.0

37 Systems - 13 Benchmark Results

Intel Core i7-3615QM - Apple Mac-C3EC7CD22292981F - Intel 3rd Gen Core DRAM

Gentoo 2.6 - 5.8.0-gentoo-r1test - MATE 1.24.0

5 Systems - 200 Benchmark Results

AMD EPYC 7F72 24-Core - ASRockRack EPYCD8 - AMD Starship

Ubuntu 20.04 - 5.8.0-pts - GNOME Shell 3.36.4

15 Systems - 14 Benchmark Results

Intel Core i7-3615QM - Apple Mac-C3EC7CD22292981F - Intel 3rd Gen Core DRAM

Gentoo 2.6 - 5.8.0-xanmod1-x86_64clang - MATE 1.24.0

35 Systems - 13 Benchmark Results

Intel Core i7-3615QM - Apple Mac-C3EC7CD22292981F - Intel 3rd Gen Core DRAM

Gentoo 2.6 - 5.4.46-gentoo-x86_64 - MATE 1.24.0

Most Popular Test Results

Find More Test Results


User Comments

Post A Comment