SqLite

SqLite

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2011262-FI-SQLITE22594
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
SqLite
November 27 2020
  16 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):


SqLiteOpenBenchmarking.orgPhoronix Test Suite2 x Intel Xeon Gold 6230R @ 4.00GHz (52 Cores / 104 Threads)Intel S2600WFT (SE5C620.86B.02.01.0012.070720200218 BIOS)Intel Sky Lake-E DMI3 Registers32 GB + 129408 MB + 32 GB + 32 GB + 32 GB + 129408 MB + 32 GB + 32 GB + 32 GB + 129408 MB + 32 GB + 32 GB + 32 GB + 129408 MB + 32 GB + 32 GB DDR4-2666MT/s8 x 3201GB INTEL SSDPE2KE032T8 + 240GB INTEL SSDSCKKB24ASPEED4 x Intel E810-C for SFP + 2 x Intel X722 for 10GBASE-TOracle Linux Server 8.24.18.0-193.28.1.el8_2.x86_64 (x86_64)GNOME Shell 3.32.2X ServerGCC 8.3.1 20191121xfs1024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionSqLite BenchmarksSystem Logs- --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver - NONE / attr2,inode64,noquota,relatime,rw,seclabel- Scaling Governor: intel_pstate performance - CPU Microcode: 0x5003003- SELinux + itlb_multihit: KVM: Vulnerable + 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 Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

SqLitesqlite: 1sqlite: 8sqlite: 32sqlite: 64sqlite: 128SqLite4.95211.13636.59471.482135.112OpenBenchmarking.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: 1SqLite1.11422.22843.34264.45685.571SE +/- 0.002, N = 34.9521. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8SqLite3691215SE +/- 0.12, N = 1511.141. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32SqLite816243240SE +/- 0.09, N = 336.591. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 64SqLite1632486480SE +/- 0.03, N = 371.481. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 128SqLite306090120150SE +/- 0.29, N = 3135.111. (CC) gcc options: -O2 -lz -lm -ldl -lpthread