SQLite Benchmark

Win10DockerForWindows

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

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Disable Color Branding
Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Windows2016
April 02 2019
  1 Minute
Win10DockerForWindows
April 03 2019
  1 Minute
Invert Hiding All Results Option
  1 Minute

Windows2016

Processor: Intel Core i3-8100 (2 Cores), Motherboard: Microsoft Virtual Machine (Hyper-V UEFI v1.0 BIOS), Memory: 4096MB, Disk: 64GB Virtual Disk

OS: Clear Linux OS 27600, Kernel: 4.9.125-linuxkit (x86_64), Compiler: GCC 8.2.1 20180502 + Clang 7.0.1 + LLVM 7.0.1, File-System: overlayfs, System Layer: container-other

Compiler Notes: --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --enable-__cxa_atexit --enable-bootstrap --enable-clocale=gnu --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell
Disk Scheduler Notes: DEADLINE
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline + PTE Inversion

Win10DockerForWindows

Changed Motherboard to Microsoft Virtual Machine (Hyper-V UEFI v3.0 BIOS).

Security Change: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

SQLite BenchmarkOpenBenchmarking.orgPhoronix Test SuiteIntel Core i3-8100 (2 Cores)Microsoft Virtual Machine (Hyper-V UEFI v1.0 BIOS)Microsoft Virtual Machine (Hyper-V UEFI v3.0 BIOS)4096MB64GB Virtual DiskClear Linux OS 276004.9.125-linuxkit (x86_64)GCC 8.2.1 20180502 + Clang 7.0.1 + LLVM 7.0.1overlayfscontainer-otherProcessorMotherboardsMemoryDiskOSKernelCompilerFile-SystemSystem LayerSQLite Benchmark PerformanceSystem Logs- --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --enable-__cxa_atexit --enable-bootstrap --enable-clocale=gnu --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell - DEADLINE- Windows2016: KPTI + __user pointer sanitization + Full generic retpoline + PTE Inversion - Win10DockerForWindows: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

SQLite

Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.26.0Timed SQLite InsertionsWindows2016Win10DockerForWindows48121620SE +/- 0.14, N = 3SE +/- 0.05, N = 312.6014.97
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.26.0Timed SQLite InsertionsWindows2016Win10DockerForWindows48121620Min: 12.38 / Avg: 12.6 / Max: 12.87Min: 14.92 / Avg: 14.97 / Max: 15.07

Windows2016

Processor: Intel Core i3-8100 (2 Cores), Motherboard: Microsoft Virtual Machine (Hyper-V UEFI v1.0 BIOS), Memory: 4096MB, Disk: 64GB Virtual Disk

OS: Clear Linux OS 27600, Kernel: 4.9.125-linuxkit (x86_64), Compiler: GCC 8.2.1 20180502 + Clang 7.0.1 + LLVM 7.0.1, File-System: overlayfs, System Layer: container-other

Compiler Notes: --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --enable-__cxa_atexit --enable-bootstrap --enable-clocale=gnu --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell
Disk Scheduler Notes: DEADLINE
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline + PTE Inversion

Testing initiated at 2 April 2019 13:23 by user root.

Win10DockerForWindows

Processor: Intel Core i3-8100 (2 Cores), Motherboard: Microsoft Virtual Machine (Hyper-V UEFI v3.0 BIOS), Memory: 4096MB, Disk: 64GB Virtual Disk

OS: Clear Linux OS 27600, Kernel: 4.9.125-linuxkit (x86_64), Compiler: GCC 8.2.1 20180502 + Clang 7.0.1 + LLVM 7.0.1, File-System: overlayfs, System Layer: container-other

Compiler Notes: --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --enable-__cxa_atexit --enable-bootstrap --enable-clocale=gnu --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell
Disk Scheduler Notes: DEADLINE
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

Testing initiated at 3 April 2019 05:16 by user root.