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/2405074-NE-SQLITESPE38&sro.

sqlite-speedtest-1.0.1runProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDisplay ServerCompilerFile-SystemScreen ResolutionNewGVNTrunkO2NewGVNTrunkO3NoGVNTrunkO2NoGVNTrunkO3GVNTrunkO2GVNTrunkO3NoPREO2NoPREO32 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-437.el9.x86_64 (x86_64)X ServerGCC 11.4.1 20231218 + PGI Compiler 16.10-0 + LLVM 3.1 + CUDA 11.2ext41024x768OpenBenchmarking.orgKernel Details- Transparent Huge Pages: alwaysEnvironment Details- NewGVNTrunkO2: CXXFLAGS="-O2 -mllvm -enable-newgvn" CFLAGS="-O2 -mllvm -enable-newgvn"- NewGVNTrunkO3: CXXFLAGS="-O3 -mllvm -enable-newgvn" CFLAGS="-O3 -mllvm -enable-newgvn"- NoGVNTrunkO2: CXXFLAGS=-O2 CFLAGS=-O2- NoGVNTrunkO3: CXXFLAGS=-O3 CFLAGS=-O3- GVNTrunkO2: CXXFLAGS=-O2 CFLAGS=-O2- GVNTrunkO3: CXXFLAGS=-O3 CFLAGS=-O3- NoPREO2: CXXFLAGS=-O2 CFLAGS=-O2- NoPREO3: CXXFLAGS=-O3 CFLAGS=-O3Compiler 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 + 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 + srbds: Not affected + tsx_async_abort: Not affected

sqlite-speedtest-1.0.1runsqlite-speedtest: Timed Time - Size 1,000DifferenceStandard ErrorStandard DeviationNewGVNTrunkO2NewGVNTrunkO3NoGVNTrunkO2NoGVNTrunkO3GVNTrunkO2GVNTrunkO3NoPREO2NoPREO3147.6191.01x1.471.73%146.9021.01x0.921.09%144.9641.02x1.001.19%147.4891.01x0.080.10%145.1401.02x1.171.40%147.6011.01x0.470.56%146.7631.01x0.951.12%148.4671.00x0.790.92%OpenBenchmarking.org

SQLite Speedtest

Timed Time - Size 1,000

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000GVNTrunkO2GVNTrunkO3NewGVNTrunkO2NewGVNTrunkO3NoGVNTrunkO2NoGVNTrunkO3NoPREO2NoPREO3306090120150SE +/- 1.17, N = 3SE +/- 0.47, N = 3SE +/- 1.47, N = 3SE +/- 0.92, N = 3SE +/- 1.00, N = 3SE +/- 0.08, N = 3SE +/- 0.95, N = 3SE +/- 0.79, N = 3145.14147.60147.62146.90144.96147.49146.76148.47

Phoronix Test Suite v10.8.5