sqlite-desktop

Intel Core i5-4690K testing with a MSI Z97S SLI Krait Edition (MS-7922) v2.0 (V10.6 BIOS) and MSI NVIDIA GeForce GTX 1050 Ti 4GB 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 2011110-NE-SQLITEDES69
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
desktop
November 11 2020
  2 Hours, 42 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):

desktop

Processor: Intel Core i5-4690K @ 3.90GHz (4 Cores), Motherboard: MSI Z97S SLI Krait Edition (MS-7922) v2.0 (V10.6 BIOS), Chipset: Intel 4th Gen Core DRAM, Memory: 16GB, Disk: 500GB Hitachi HTS72505 + 750GB Seagate ST9750420AS + 1000GB Western Digital WD10JPVX-22J + 240GB SanDisk SDSSDA24 + 120GB KINGSTON SV300S3, Graphics: MSI NVIDIA GeForce GTX 1050 Ti 4GB, Audio: Realtek ALC892, Monitor: VE248 + MX259, Network: Realtek RTL8111/8168/8411 + Intel Wi-Fi 6 AX200

OS: Arch rolling, Kernel: 5.9.6-zen1-1-zen (x86_64), Desktop: KDE Plasma 5.20.3, Display Server: X Server 1.20.8, Display Driver: NVIDIA 455.38, OpenGL: 4.6.0, Vulkan: 1.2.142, Compiler: GCC 10.2.0 + Clang 11.0.0Target: + LLVM 11.0.0 + CUDA 11.1, File-System: ext4, Screen Resolution: 3840x1080

Compiler Notes: --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 Notes: BFQ / relatime,rw,stripe=32
Processor Notes: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x1d
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Vulnerable: Clear buffers attempted no microcode; SMT disabled + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Not affected

sqlite-desktopOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-4690K @ 3.90GHz (4 Cores)MSI Z97S SLI Krait Edition (MS-7922) v2.0 (V10.6 BIOS)Intel 4th Gen Core DRAM16GB500GB Hitachi HTS72505 + 750GB Seagate ST9750420AS + 1000GB Western Digital WD10JPVX-22J + 240GB SanDisk SDSSDA24 + 120GB KINGSTON SV300S3MSI NVIDIA GeForce GTX 1050 Ti 4GBRealtek ALC892VE248 + MX259Realtek RTL8111/8168/8411 + Intel Wi-Fi 6 AX200Arch rolling5.9.6-zen1-1-zen (x86_64)KDE Plasma 5.20.3X Server 1.20.8NVIDIA 455.384.6.01.2.142GCC 10.2.0 + Clang 11.0.0Targetext43840x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionSqlite-desktop BenchmarksSystem Logs- --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 - BFQ / relatime,rw,stripe=32- Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x1d- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Vulnerable: Clear buffers attempted no microcode; SMT disabled + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Not affected

sqlite-desktopsqlite: 1sqlite: 8sqlite: 32sqlite: 64sqlite: 128desktop31.12346.117172.063364.409620.250OpenBenchmarking.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. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1desktop714212835SE +/- 8.82, N = 1231.121. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8desktop1020304050SE +/- 0.94, N = 1246.121. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32desktop4080120160200SE +/- 5.44, N = 12172.061. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 64desktop80160240320400SE +/- 1.03, N = 3364.411. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 128desktop130260390520650SE +/- 19.88, N = 9620.251. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

desktop

Processor: Intel Core i5-4690K @ 3.90GHz (4 Cores), Motherboard: MSI Z97S SLI Krait Edition (MS-7922) v2.0 (V10.6 BIOS), Chipset: Intel 4th Gen Core DRAM, Memory: 16GB, Disk: 500GB Hitachi HTS72505 + 750GB Seagate ST9750420AS + 1000GB Western Digital WD10JPVX-22J + 240GB SanDisk SDSSDA24 + 120GB KINGSTON SV300S3, Graphics: MSI NVIDIA GeForce GTX 1050 Ti 4GB, Audio: Realtek ALC892, Monitor: VE248 + MX259, Network: Realtek RTL8111/8168/8411 + Intel Wi-Fi 6 AX200

OS: Arch rolling, Kernel: 5.9.6-zen1-1-zen (x86_64), Desktop: KDE Plasma 5.20.3, Display Server: X Server 1.20.8, Display Driver: NVIDIA 455.38, OpenGL: 4.6.0, Vulkan: 1.2.142, Compiler: GCC 10.2.0 + Clang 11.0.0Target: + LLVM 11.0.0 + CUDA 11.1, File-System: ext4, Screen Resolution: 3840x1080

Compiler Notes: --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 Notes: BFQ / relatime,rw,stripe=32
Processor Notes: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x1d
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Vulnerable: Clear buffers attempted no microcode; SMT disabled + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Not affected

Testing initiated at 11 November 2020 09:38 by user alex.