sqlite3 4 x Intel Xeon Gold 6130 testing with a Dell PowerEdge R940 [0D41HC] (2.15.1 BIOS) and Matrox G200eW3 on Debian GNU/Linux 11 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2308155-NE-SQLITE30169 .
sqlite3 Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Vulkan Compiler File-System Screen Resolution patched nopatch 4 x Intel Xeon Gold 6130 @ 3.70GHz (64 Cores / 128 Threads) Dell PowerEdge R940 [0D41HC] (2.15.1 BIOS) Intel Sky Lake-E DMI3 Registers 24 x 32 GB DDR4-2666MT/s 36ASF4G72PZ-2G6D1 1600GB Dell Flash PM1725b 1.6TB AIC + 1600GB Dell Flash NVMe PM1725 1.6TB AIC + 480GB INTEL SSDSC2KG480G7R Matrox G200eW3 4 x Intel X710 for 10GbE SFP+ Debian GNU/Linux 11 6.1.38 (x86_64) 1.0.2 GCC 10.2.1 20210110 ext4 1024x768 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: always Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,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-build-config=bootstrap-lto-lean --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 Disk Details - MQ-DEADLINE / errors=remount-ro,relatime,rw / Block Size: 4096 Processor Details - Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0x2006e05 Security Details - itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable
sqlite3 sqlite: 1 sqlite: 2 sqlite: 4 sqlite: 8 sqlite: 16 sqlite: 32 sqlite: 64 sqlite: 128 patched nopatch 2.244 3.408 5.096 7.906 12.030 18.738 50.903 107.595 2.802 3.749 5.478 8.487 13.049 21.819 54.350 108.022 OpenBenchmarking.org
SQLite Threads / Copies: 1 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 1 patched nopatch 0.6305 1.261 1.8915 2.522 3.1525 SE +/- 0.022, N = 15 SE +/- 0.083, N = 12 2.244 2.802 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 2 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 2 patched nopatch 0.8435 1.687 2.5305 3.374 4.2175 SE +/- 0.010, N = 3 SE +/- 0.028, N = 3 3.408 3.749 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 4 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 4 patched nopatch 1.2326 2.4652 3.6978 4.9304 6.163 SE +/- 0.040, N = 15 SE +/- 0.056, N = 3 5.096 5.478 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 8 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 8 patched nopatch 2 4 6 8 10 SE +/- 0.090, N = 3 SE +/- 0.041, N = 3 7.906 8.487 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 16 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 16 patched nopatch 3 6 9 12 15 SE +/- 0.03, N = 3 SE +/- 0.06, N = 3 12.03 13.05 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 32 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 32 patched nopatch 5 10 15 20 25 SE +/- 0.05, N = 3 SE +/- 0.16, N = 3 18.74 21.82 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 64 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 64 patched nopatch 12 24 36 48 60 SE +/- 0.57, N = 12 SE +/- 0.41, N = 3 50.90 54.35 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
SQLite Threads / Copies: 128 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 128 patched nopatch 20 40 60 80 100 SE +/- 0.38, N = 3 SE +/- 0.27, N = 3 107.60 108.02 1. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
Phoronix Test Suite v10.8.5