SQLite Benchmark

WinServer2019

HTML result view exported from: https://openbenchmarking.org/result/1904051-SP-1904038SP40.

SQLite BenchmarkProcessorMotherboardMemoryDiskOSKernelCompilerFile-SystemSystem LayerWindows2016Win10DockerForWindowsWin10ToolBoxWinServer2019Intel Core i3-8100 (2 Cores)Microsoft Virtual Machine (Hyper-V UEFI v1.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-otherMicrosoft Virtual Machine (Hyper-V UEFI v3.0 BIOS)Intel Core i3-8100 (1 Core)Oracle VirtualBox v1.221GB VBOX HDD4.14.104-boot2docker (x86_64)Oracle VirtualBoxIntel Core i3-8100 (2 Cores)Microsoft Virtual Machine (Hyper-V UEFI v4.0 BIOS)64GB Virtual Disk4.9.125-linuxkit (x86_64)container-otherOpenBenchmarking.orgCompiler Details- --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 Details- DEADLINESecurity Details- Windows2016: KPTI + __user pointer sanitization + Full generic retpoline + PTE Inversion- Win10DockerForWindows: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion- Win10ToolBox: KPTI + __user pointer sanitization + Full generic retpoline STIBP: disabled RSB filling + PTE Inversion- WinServer2019: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

SQLite Benchmarksqlite: Timed SQLite InsertionsDifferenceStandard ErrorStandard DeviationWindows2016Win10DockerForWindowsWin10ToolBoxWinServer201912.601.73x0.141.99%14.971.68x0.050.57%46.311.00x0.070.27%13.081.72x0.060.83%OpenBenchmarking.org

SQLite

Timed SQLite Insertions

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.26.0Timed SQLite InsertionsWindows2016Win10DockerForWindowsWin10ToolBoxWinServer20191122334455SE +/- 0.14, N = 3SE +/- 0.05, N = 3SE +/- 0.07, N = 3SE +/- 0.06, N = 312.6014.9746.3113.08

Phoronix Test Suite v10.8.4