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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2402140-NE-SQLITEALL45
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT
February 14
  11 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


sqliteallOpenBenchmarking.orgPhoronix Test SuiteAMD 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.1ext43840x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionSqliteall BenchmarksSystem Logs- 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: 16sqlite: 8sqlite: 4sqlite: 2sqlite: 1sqlite: 32AMD Ryzen 9 5950X 16-Core - MSI NVIDIA GeForce GT18.17614.10613.12610.0478.34729.285OpenBenchmarking.org

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database with a variable number of concurrent repetitions -- up to the maximum number of CPU threads available. Learn more via the OpenBenchmarking.org test page.

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

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

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

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

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

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