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 2311095-NE-SQLITE22097
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
sqlite-2.2.0-base
November 08 2023
  14 Hours, 4 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-base

Processor: Intel Core i5-10500 @ 4.50GHz (6 Cores / 12 Threads), Motherboard: Dell 0NDYHG (1.5.2 BIOS), Chipset: Intel Tiger Lake-H, Memory: 8GB, Disk: 1000GB MB001000GWFGF + 0GB SD Card Reader, Graphics: Intel CometLake-S GT2 [UHD 630] (1150MHz), Audio: Realtek ALC3246, Monitor: LS24A40xU, Network: Intel

OS: Debian 12, Kernel: 6.1.0-13-amd64 (x86_64), Desktop: GNOME Shell 43.6, Display Server: X Server, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: always
Environment Notes: FLAGS= LDFLAGS=
Disk Notes: MQ-DEADLINE / errors=remount-ro,relatime,rw / Block Size: 4096
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xf8
Security Notes: gather_data_sampling: Mitigation of Microcode + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of Enhanced IBRS + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Mitigation of Microcode + tsx_async_abort: Not affected

sqlite-2.2.0-baseOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-10500 @ 4.50GHz (6 Cores / 12 Threads)Dell 0NDYHG (1.5.2 BIOS)Intel Tiger Lake-H8GB1000GB MB001000GWFGF + 0GB SD Card ReaderIntel CometLake-S GT2 [UHD 630] (1150MHz)Realtek ALC3246LS24A40xUIntelDebian 126.1.0-13-amd64 (x86_64)GNOME Shell 43.6X ServerGCC 12.2.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionSqlite-2.2.0-base BenchmarksSystem Logs- Transparent Huge Pages: always- FLAGS= LDFLAGS=- MQ-DEADLINE / errors=remount-ro,relatime,rw / Block Size: 4096- Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xf8 - gather_data_sampling: Mitigation of Microcode + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of Enhanced IBRS + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Mitigation of Microcode + tsx_async_abort: Not affected

sqlite-2.2.0-basesqlite: 1sqlite: 2sqlite: 4sqlite: 8sqlite: 12sqlite-2.2.0-base515.7891210.0451922.9232786.0541487.706OpenBenchmarking.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-base110220330440550SE +/- 25.99, N = 6515.79

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

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

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8sqlite-2.2.0-base6001200180024003000SE +/- 31.94, N = 92786.05

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 12sqlite-2.2.0-base300600900120015001487.71

sqlite-2.2.0-base

Processor: Intel Core i5-10500 @ 4.50GHz (6 Cores / 12 Threads), Motherboard: Dell 0NDYHG (1.5.2 BIOS), Chipset: Intel Tiger Lake-H, Memory: 8GB, Disk: 1000GB MB001000GWFGF + 0GB SD Card Reader, Graphics: Intel CometLake-S GT2 [UHD 630] (1150MHz), Audio: Realtek ALC3246, Monitor: LS24A40xU, Network: Intel

OS: Debian 12, Kernel: 6.1.0-13-amd64 (x86_64), Desktop: GNOME Shell 43.6, Display Server: X Server, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: always
Environment Notes: FLAGS= LDFLAGS=
Disk Notes: MQ-DEADLINE / errors=remount-ro,relatime,rw / Block Size: 4096
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xf8
Security Notes: gather_data_sampling: Mitigation of Microcode + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of Enhanced IBRS + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Mitigation of Microcode + tsx_async_abort: Not affected

Testing initiated at 8 November 2023 17:48 by user lucian.