sqlite-test AMD Ryzen 7 1700X Eight-Core testing with a ASUS PRIME B350-PLUS (5407 BIOS) and Gigabyte AMD Radeon HD 7850 / R7 265 R9 270 1024SP 2GB on Arch rolling via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2005110-NI-2005111NI38 .
sqlite-test Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution nvme500 2TB Samsung HD204UI 2TB Samsung HD204UI 2 intel120 intel120 take2 AMD Ryzen 7 1700X Eight-Core @ 3.40GHz (8 Cores / 16 Threads) ASUS PRIME B350-PLUS (5407 BIOS) AMD 17h 16GB 500GB KINGSTON SA2000M8500G + 2000GB SAMSUNG HD204UI + 500GB Seagate ST9500325ASG + 120GB INTEL SSDSA2CW12 Gigabyte AMD Radeon HD 7850 / R7 265 R9 270 1024SP 2GB AMD Oland/Hainan/Cape DELL U2711 Realtek RTL8111/8168/8411 + Intel 8265 / 8275 Arch rolling 5.6.12-1-pelle (x86_64) GNOME Shell 3.36.2 X Server 1.20.4 + Wayland 4.6 Mesa 20.2.0-devel (git-b0cb38f360) (LLVM 10.0.0) 1.2.128 GCC 9.3.0 + Clang 10.0.0 + LLVM 10.0.0 btrfs 2560x1440 xfs btrfs OpenBenchmarking.org Kernel Details - radeon.si_support=0 radeon.cik_support=0 amdgpu.si_support=1 amdgpu.cik_support=1 amdgpu.gpu_recovery=1 amdgpu.audio=0 Environment Details - RADV_PERFTEST=aco CXXFLAGS="-march=native -O2" CFLAGS="-march=native -O2" Compiler Details - --disable-libssp --disable-libstdcxx-pch --disable-libunwind-exceptions --disable-werror --enable-__cxa_atexit --enable-cet=auto --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-gnu-indirect-function --enable-gnu-unique-object --enable-install-libiberty --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++,d --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-isl --with-linker-hash-style=gnu Disk Details - nvme500: NONE / compress-force=zstd:3,noatime,rw,space_cache,ssd,subvol=/,subvolid=5 - 2TB Samsung HD204UI: NONE / compress-force=zstd:3,noatime,rw,space_cache,ssd,subvol=/,subvolid=5 - 2TB Samsung HD204UI 2: NONE / compress-force=zstd:3,noatime,rw,space_cache,ssd,subvol=/,subvolid=5 - intel120: NONE / compress-force=zstd:3,noatime,rw,space_cache,ssd,subvol=/,subvolid=5 - intel120 take2: NONE / compress-force=zstd:3,relatime,rw,space_cache,ssd,subvol=/,subvolid=5 Processor Details - Scaling Governor: acpi-cpufreq performance - CPU Microcode: 0x8001138 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + 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 AMD retpoline IBPB: conditional STIBP: disabled RSB filling + tsx_async_abort: Not affected
sqlite-test sqlite: 1 sqlite: 8 sqlite: 32 nvme500 2TB Samsung HD204UI 2TB Samsung HD204UI 2 intel120 intel120 take2 22.460 39.444 180.554 542.039 3495.644 24.229 61.179 229.669 OpenBenchmarking.org
SQLite Threads / Copies: 1 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 1 nvme500 2TB Samsung HD204UI 2 intel120 take2 120 240 360 480 600 SE +/- 0.60, N = 15 SE +/- 8.31, N = 9 SE +/- 0.41, N = 3 22.46 542.04 24.23 1. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread
SQLite Threads / Copies: 8 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 8 nvme500 2TB Samsung HD204UI 2 intel120 take2 700 1400 2100 2800 3500 SE +/- 0.08, N = 3 SE +/- 63.76, N = 3 SE +/- 0.67, N = 3 39.44 3495.64 61.18 1. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread
SQLite Threads / Copies: 32 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 32 nvme500 intel120 take2 50 100 150 200 250 SE +/- 1.76, N = 12 SE +/- 3.85, N = 4 180.55 229.67 1. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread
Phoronix Test Suite v10.8.4