wsl-sqlite-speedtest

microsoft testing on Ubuntu 20.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2005190-NI-2005190NI74.

wsl-sqlite-speedtestProcessorMemoryDiskOSKernelCompilerFile-SystemSystem LayerWindows 10 2004 19041.2640 WSLWindows 10 2004 19041.2640 WSL2Intel Core i7-7700HQ @ 2.81GHz (4 Cores / 8 Threads)16GB117GBUbuntu 20.044.4.0-19041-Microsoft (x86_64)GCC 9.3.0wslfswslIntel Core i7-7700HQ (4 Cores / 8 Threads)14GB2 x 275GB Virtual Disk4.19.84-microsoft-standard (x86_64)ext4microsoftOpenBenchmarking.orgCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details- CPU Microcode: 0xffffffffSecurity Details- Windows 10 2004 19041.2640 WSL2: itlb_multihit: vulnerable + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + 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 + tsx_async_abort: Not affected

wsl-sqlite-speedtestsqlite-speedtest: Timed Time - Size 1,000DifferenceStandard ErrorStandard DeviationWindows 10 2004 19041.2640 WSLWindows 10 2004 19041.2640 WSL2323.8871.00x2.971.59%80.1771.75x0.691.48%OpenBenchmarking.org

SQLite Speedtest

Timed Time - Size 1,000

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000Windows 10 2004 19041.2640 WSLWindows 10 2004 19041.2640 WSL270140210280350SE +/- 2.97, N = 3SE +/- 0.69, N = 3323.8980.18-lz1. (CC) gcc options: -O2 -ldl -lpthread


Phoronix Test Suite v10.8.4