sqlite-speedtest-1.0.1run

2 x Intel Xeon E5-2620 v2 testing with a ASUS Z9PE-D8 WS (5503 BIOS) and ASPEED on CentOS Stream 9 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2410192-NE-SQLITESPE39&grs.

sqlite-speedtest-1.0.1runProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkMonitorOSKernelDisplay ServerDisplay DriverCompilerFile-SystemScreen ResolutiondebugNoGVNO2NoGVNO3OptNoSimplO2OptNoSimplO3OptSimplO2OptSimplO3OptRedO22024-08-06 10:34OptPREO2GVNO2NewGVNO2OptRedO3OptPREO3NewGVNO333GVNO3PessimisticO3PessimisticO2PessimisticNewGVNO2PessimisticNewGVNO32024-10-19 23:212 x Intel Xeon E5-2620 v2 @ 2.60GHz (12 Cores / 24 Threads)ASUS Z9PE-D8 WS (5503 BIOS)Intel Xeon E7 v2/Xeon32GB256GB Samsung SSD 850 + 2000GB Western Digital WD20EARX-00PASPEEDRealtek ALC8982 x Intel 82574LCentOS Stream 95.14.0-467.el9.x86_64 (x86_64)X ServerNVIDIAGCC 11.4.1 20231218 + PGI Compiler 16.10-0 + LLVM 3.1 + CUDA 11.2ext41024x7682000GB Western Digital WD20EARX-00P + 256GB Samsung SSD 850ASUS VW1905.14.0-474.el9.x86_64 (x86_64)5.14.0-480.el9.x86_64 (x86_64)256GB Samsung SSD 850 + 2000GB Western Digital WD20EARX-00P5.14.0-496.el9.x86_64 (x86_64)GCC 11.5.0 20240719 + PGI Compiler 16.10-0 + LLVM 3.1 + CUDA 11.25.14.0-503.el9.x86_64 (x86_64)5.14.0-514.el9.x86_64 (x86_64)OpenBenchmarking.orgKernel Details- Transparent Huge Pages: alwaysEnvironment Details- debug: CXXFLAGS=-O2 CFLAGS=-O2- NoGVNO2: CXXFLAGS="-O2 -mllvm -enable-newgvn -mllvm -disable-gvn=true" CFLAGS="-O2 -mllvm -enable-newgvn -mllvm -disable-gvn=true"- NoGVNO3: CXXFLAGS="-O3 -mllvm -enable-newgvn -mllvm -disable-gvn=true" CFLAGS="-O3 -mllvm -enable-newgvn -mllvm -disable-gvn=true"- OptNoSimplO2: CXXFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=false" CFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=false"- OptNoSimplO3: CXXFLAGS="-O3 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=false" CFLAGS="-O3 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=false"- OptSimplO2: CXXFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=true" CFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=true"- OptSimplO3: CXXFLAGS="-O3 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=true" CFLAGS="-O3 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=false -mllvm -enable-newgvn-pre=false -mllvm -enable-newgvn-simpl=true"- OptRedO2: CXXFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=true -mllvm -enable-newgvn-simpl=true -mllvm -enable-newgvn-pre=false" CFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-phi-of-ops=true -mllvm -enable-newgvn-simpl=true -mllvm -enable-newgvn-pre=false"- 2024-08-06 10:34: CXXFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-newgvn-pre=false" CFLAGS="-O2 -mllvm -enable-newgvn -mllvm -enable-newgvn-pre=false"- OptPREO2: CXXFLAGS="-O2 -mllvm -enable-newgvn" CFLAGS="-O2 -mllvm -enable-newgvn"- GVNO2: CXXFLAGS=-O2 CFLAGS=-O2- NewGVNO2: CXXFLAGS="-O2 -mllvm -enable-newgvn" CFLAGS="-O2 -mllvm -enable-newgvn"- OptRedO3: CXXFLAGS="-O3 -mllvm -enable-newgvn -mllvm -enable-newgvn-pre=false" CFLAGS="-O3 -mllvm -enable-newgvn -mllvm -enable-newgvn-pre=false"- OptPREO3: CXXFLAGS="-O3 -mllvm -enable-newgvn" CFLAGS="-O3 -mllvm -enable-newgvn"- NewGVNO333: CXXFLAGS="-O3 -mllvm -enable-newgvn" CFLAGS="-O3 -mllvm -enable-newgvn"- GVNO3: CXXFLAGS=-O3 CFLAGS=-O3- PessimisticO3: CXXFLAGS=-O3 CFLAGS=-O3- PessimisticO2: CXXFLAGS=-O2 CFLAGS=-O2- PessimisticNewGVNO2: CXXFLAGS="-O2 -mllvm -enable-newgvn" CFLAGS="-O2 -mllvm -enable-newgvn"- PessimisticNewGVNO3: CXXFLAGS="-O3 -mllvm -enable-newgvn" CFLAGS="-O3 -mllvm -enable-newgvn"- 2024-10-19 23:21: CXXFLAGS="-O2 -mllvm -enable-newgvn" CFLAGS="-O2 -mllvm -enable-newgvn"Compiler Details- Optimized build with assertions; Built Apr 11 2013 (07:43:48); Default target: i386-pc-linux-gnu; Host CPU: i686Processor Details- Scaling Governor: intel_cpufreq conservative - CPU Microcode: 0x42eSecurity Details- gather_data_sampling: Not affected + 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: Unknown: No mitigations + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines; IBPB: conditional; IBRS_FW; STIBP: conditional; RSB filling; PBRSB-eIBRS: Not affected; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

sqlite-speedtest-1.0.1runsqlite-speedtest: Timed Time - Size 1,000sqlite-speedtest: DifferenceStandard ErrorStandard DeviationdebugNoGVNO2NoGVNO3OptNoSimplO2OptNoSimplO3OptSimplO2OptSimplO3OptRedO22024-08-06 10:34OptPREO2GVNO2NewGVNO2OptRedO3OptPREO3NewGVNO333GVNO3PessimisticO3PessimisticO2PessimisticNewGVNO2PessimisticNewGVNO32024-10-19 23:21145.8851.02x1.591.89%149.4671.00x1.241.44%146.5501.02x0.360.43%148.6611.01x0.400.47%147.1451.02x0.790.93%146.0761.02x0.881.05%144.8361.03x0.330.40%146.3181.02x0.600.71%146.2771.02x1.421.68%145.5111.03x0.250.30%146.6501.02x0.690.81%146.5151.02x1.912.26%144.9781.03x0.660.79%148.6701.01x0.470.55%145.1721.03x1.251.49%147.9441.01x0.861.01%144.8861.03x0.440.53%147.8611.01x1.101.29%146.7241.02x0.650.76%148.8431.00x0.790.92%OpenBenchmarking.org

SQLite Speedtest

Timed Time - Size 1,000

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000debugNoGVNO2NoGVNO3OptNoSimplO2OptNoSimplO3OptSimplO2OptSimplO3OptRedO22024-08-06 10:34OptPREO2GVNO2NewGVNO2OptRedO3OptPREO3NewGVNO333GVNO3PessimisticO3PessimisticO2PessimisticNewGVNO2PessimisticNewGVNO3306090120150SE +/- 1.59, N = 3SE +/- 1.24, N = 3SE +/- 0.36, N = 3SE +/- 0.40, N = 3SE +/- 0.79, N = 3SE +/- 2.03, N = 3SE +/- 1.45, N = 3SE +/- 0.60, N = 3SE +/- 1.42, N = 3SE +/- 0.25, N = 3SE +/- 0.69, N = 3SE +/- 1.91, N = 3SE +/- 0.66, N = 3SE +/- 0.47, N = 3SE +/- 1.25, N = 3SE +/- 0.86, N = 3SE +/- 0.44, N = 3SE +/- 1.10, N = 3SE +/- 0.65, N = 3SE +/- 0.79, N = 3145.89149.47146.55148.66147.15146.66148.42146.32146.28145.51146.65146.52144.98148.67145.17147.94144.89147.86146.72148.84

SQLite Speedtest

Test Install Size

OpenBenchmarking.orgBytes, Fewer Is BetterSQLite Speedtest 3.30Test Install Size2024-10-19 23:2130K60K90K120K150K150996

Phoronix Test Suite v10.8.5