sql

result

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

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
sql
October 05
  46 Minutes


sqlOpenBenchmarking.orgPhoronix Test SuiteIntel Pentium D @ 3.40GHz (2 Cores)Intel SE7230NH1LX (NH72310J.86B.1104.2006.0322.1002 BIOS)Intel E7230/3000/3010 + ICH74 x 1 GB DDR2-533MT/s2 x 500GB HDS725050KLA360 + 31GB ProductCodellvmpipeSyncMasterIntel 82545GM + Intel 82573E + Intel 82541GIManjaroLinux 24.1.06.10.11-2-MANJARO (x86_64)Xfce 4.18X Server 1.21.1.134.5 Mesa 24.2.2-arch1.1 (LLVM 18.1.8 128 bits)GCC 14.2.1 20240910ext41280x1024ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionSql BenchmarksSystem Logs- Transparent Huge Pages: always- MQ-DEADLINE / noatime,rw / Block Size: 4096- Scaling Governor: acpi-cpufreq schedutil - CPU Microcode: 0x0- gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX unsupported + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: 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; BHI: Not affected + srbds: Not affected + 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 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: 1sql100200300400500SE +/- 24.26, N = 6458.401. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm