sqlite-2.2.0-base

sqlite-2.2.0-base

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2310260-NE-SQLITE22078
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-2.2.0-base
October 25 2023
  1 Day, 6 Hours, 24 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):


sqlite-2.2.0-baseOpenBenchmarking.orgPhoronix Test Suite2 x Intel Xeon E5-2680 v2 @ 3.60GHz (20 Cores / 40 Threads)HP 158A (J61 v03.69 BIOS)Intel Xeon E7 v2/Xeon64GB2000GB TOSHIBA DT01ACA2 + 256GB SanDisk SD8TB8U2NVIDIA NVE4 4GBRealtek ALC262LS24A40xUIntel 82579LM + Intel 82574LDebian 115.10.0-21-amd64 (x86_64)X Server 1.20.11nouveau4.3 Mesa 20.3.51.0.2GCC 10.2.1 20210110ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDisplay ServerDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionSqlite-2.2.0-base BenchmarksSystem Logs- Transparent Huge Pages: always- FLAGS=":-fwrapv:-fignore-pure-const-attrs:-fno-strict-aliasing:-fstrict-enums:-fno-delete-null-pointer-checks:-fconstrain-shift-value:-fno-finite-loops:-fno-constrain-bool-value:-fno-use-default-alignment:-fdrop-inbounds-from-gep -mllvm -disable-oob-analysis:-mllvm -zero-uninit-loads:-mllvm -disable-object-based-analysis:-fcheck-div-rem-overflow:-fdrop-noalias-restrict-attr:-fdrop-align-attr:-fdrop-deref-attr:-Xclang -no-enable-noundef-analysis:-fdrop-ub-builtins:-all" LDFLAGS= - MQ-DEADLINE / errors=remount-ro,relatime,rw / Block Size: 4096- Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x417- itlb_multihit: KVM: Mitigation of VMX unsupported + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

sqlite-2.2.0-basesqlite: 1sqlite: 2sqlite: 4sqlite: 8sqlite: 16sqlite: 32sqlite: 40sqlite-2.2.0-base568.8931290.2331961.8243299.2185530.9199243.76410862.780OpenBenchmarking.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: 1sqlite-2.2.0-base120240360480600SE +/- 11.30, N = 9568.89

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 2sqlite-2.2.0-base30060090012001500SE +/- 15.83, N = 91290.23

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 4sqlite-2.2.0-base400800120016002000SE +/- 1.00, N = 31961.82

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8sqlite-2.2.0-base7001400210028003500SE +/- 28.60, N = 33299.22

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16sqlite-2.2.0-base12002400360048006000SE +/- 24.89, N = 35530.92

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 32sqlite-2.2.0-base2K4K6K8K10KSE +/- 25.48, N = 39243.76

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 40sqlite-2.2.0-base2K4K6K8K10KSE +/- 11.64, N = 310862.78

7 Results Shown

SQLite:
  1
  2
  4
  8
  16
  32
  40