sqliteall

AMD Ryzen 9 5950X 16-Core testing with a ASUS ROG STRIX B550-F GAMING WIFI II (3405 BIOS) and MSI NVIDIA GeForce GT 1030 2GB on Ubuntu 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2402140-NE-SQLITEALL45&grr.

sqliteallProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionAMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GTAMD Ryzen 9 5950X 16-Core @ 3.40GHz (16 Cores / 32 Threads)ASUS ROG STRIX B550-F GAMING WIFI II (3405 BIOS)AMD Starship/Matisse128GB2000GB CT2000P5PSSD8 + 1000GB KINGSTON SA2000M81000G + 4001GB Western Digital WD40EZRZ-22G + 5001GB My Passport 2626 + 2000GB My Passport 0748MSI NVIDIA GeForce GT 1030 2GBNVIDIA GP108 HD Audio2 x DELL P2419HIntel I225-V + MEDIATEK Device 0608Ubuntu 22.046.7.4-zabbly+ (x86_64)MATE 1.26.0X Server 1.21.1.4NVIDIA 535.129.034.6.01.3.242GCC 11.4.0 + Clang 14.0.0-1ubuntu1.1ext43840x1080OpenBenchmarking.org- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --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-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-gcn/usr --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 - NONE / relatime,rw / Block Size: 4096- Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0xa20120e- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of Safe RET + 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: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

sqliteallsqlite: 32sqlite: 16sqlite: 8sqlite: 4sqlite: 2sqlite: 1AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT29.28518.17614.10613.12610.0478.347OpenBenchmarking.org

SQLite

Threads / Copies: 32

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 32AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT714212835SE +/- 3.22, N = 1529.291. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

SQLite

Threads / Copies: 16

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT48121620SE +/- 0.04, N = 318.181. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

SQLite

Threads / Copies: 8

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT48121620SE +/- 0.06, N = 314.111. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

SQLite

Threads / Copies: 4

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 4AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT3691215SE +/- 0.06, N = 313.131. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

SQLite

Threads / Copies: 2

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 2AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT3691215SE +/- 0.06, N = 310.051. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

SQLite

Threads / Copies: 1

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 1AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT246810SE +/- 0.018, N = 38.3471. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

Phoronix Test Suite v10.8.5