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.

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

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
nvme500
May 11 2020
  44 Minutes
2TB Samsung HD204UI
May 11 2020
 
2TB Samsung HD204UI 2
May 11 2020
  4 Hours, 17 Minutes
intel120
May 11 2020
 
intel120 take2
May 11 2020
  20 Minutes
Invert Hiding All Results Option
  1 Hour, 4 Minutes

Only show results where is faster than
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):


sqlite-testOpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen 7 1700X Eight-Core @ 3.40GHz (8 Cores / 16 Threads)ASUS PRIME B350-PLUS (5407 BIOS)AMD 17h16GB500GB KINGSTON SA2000M8500G + 2000GB SAMSUNG HD204UI + 500GB Seagate ST9500325ASG + 120GB INTEL SSDSA2CW12Gigabyte AMD Radeon HD 7850 / R7 265 R9 270 1024SP 2GBAMD Oland/Hainan/CapeDELL U2711Realtek RTL8111/8168/8411 + Intel 8265 / 8275Arch rolling5.6.12-1-pelle (x86_64)GNOME Shell 3.36.2X Server 1.20.4 + Wayland4.6 Mesa 20.2.0-devel (git-b0cb38f360) (LLVM 10.0.0)1.2.128GCC 9.3.0 + Clang 10.0.0 + LLVM 10.0.0btrfsxfs2560x1440ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemsScreen ResolutionSqlite-test BenchmarksSystem Logs- radeon.si_support=0 radeon.cik_support=0 amdgpu.si_support=1 amdgpu.cik_support=1 amdgpu.gpu_recovery=1 amdgpu.audio=0- RADV_PERFTEST=aco CXXFLAGS="-march=native -O2" CFLAGS="-march=native -O2"- --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 - 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- Scaling Governor: acpi-cpufreq performance - CPU Microcode: 0x8001138- 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

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. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1nvme5002TB Samsung HD204UI 2intel120 take2120240360480600SE +/- 0.60, N = 15SE +/- 8.31, N = 9SE +/- 0.41, N = 322.46542.0424.231. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1nvme5002TB Samsung HD204UI 2intel120 take2100200300400500Min: 20.78 / Avg: 22.46 / Max: 26.22Min: 507.36 / Avg: 542.04 / Max: 589.31Min: 23.76 / Avg: 24.23 / Max: 25.041. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8nvme5002TB Samsung HD204UI 2intel120 take27001400210028003500SE +/- 0.08, N = 3SE +/- 63.76, N = 3SE +/- 0.67, N = 339.443495.6461.181. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8nvme5002TB Samsung HD204UI 2intel120 take26001200180024003000Min: 39.3 / Avg: 39.44 / Max: 39.59Min: 3386.23 / Avg: 3495.64 / Max: 3607.07Min: 59.87 / Avg: 61.18 / Max: 62.111. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32nvme500intel120 take250100150200250SE +/- 1.76, N = 12SE +/- 3.85, N = 4180.55229.671. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32nvme500intel120 take24080120160200Min: 164.36 / Avg: 180.55 / Max: 189.53Min: 218.27 / Avg: 229.67 / Max: 234.931. (CC) gcc options: -march=native -O2 -ledit -ltinfo -lz -lm -ldl -lpthread