benchmark_sqlite

Intel Core i5-8400H testing with a Dell 0YRWN0 (1.13.1 BIOS) and Intel HD 3GB on Ubuntu 16.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2011090-FI-BENCHMARK81
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
benchmark_sqlite
November 09 2020
  37 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


benchmark_sqliteOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-8400H @ 4.20GHz (4 Cores / 8 Threads)Dell 0YRWN0 (1.13.1 BIOS)Intel Cannon Lake PCH16GBToshiba KXG50ZNV512G NVMe 512GBIntel HD 3GB (1100MHz)Realtek ALC289Intel I219-LM + Intel-AC 9260Ubuntu 16.045.8.12-master2ACDI (x86_64)Unity 7.4.5X Server 1.19.6modesetting 1.19.64.5 Mesa 18.0.5GCC 5.4.0 20160609ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionBenchmark_sqlite PerformanceSystem Logs- --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-tune=generic -v - NONE / errors=remount-ro,relatime,rw- Scaling Governor: intel_pstate powersave - CPU Microcode: 0xd6 - Thermald 1.5 - itlb_multihit: vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

benchmark_sqlitesqlite: 128sqlite: 64sqlite: 32sqlite: 8sqlite: 1benchmark_sqlite279.443187.668134.33370.48630.014OpenBenchmarking.org

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 via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 128benchmark_sqlite60120180240300SE +/- 0.08, N = 3279.441. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 64benchmark_sqlite4080120160200SE +/- 0.45, N = 3187.671. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32benchmark_sqlite306090120150SE +/- 0.96, N = 3134.331. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8benchmark_sqlite1632486480SE +/- 1.02, N = 470.491. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1benchmark_sqlite714212835SE +/- 0.33, N = 330.011. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm -ldl -lpthread