sqlite1

Intel Core i5-4460 testing with a Mouse Z97-S01 v1.0 (V2.0B5 BIOS) and MSI Intel Xeon E3-1200 v3/4th Gen Core IGP on Ubuntu 20.04 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 2403188-NE-SQLITE10220
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Toggle/Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
bcachefs replica=3
March 18
  51 Minutes
bcachefs replica=2
March 18
  18 Minutes
bcachefs replica=1
March 18
  19 Minutes
Invert Behavior (Only Show Selected Data)
  30 Minutes

Only show results where is faster than
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):


sqlite1OpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-4460 @ 3.40GHz (4 Cores)Mouse Z97-S01 v1.0 (V2.0B5 BIOS)Intel 4th Gen Core DRAM2 x 8192 MB DDR3-1600MT/s2 x 1000GB TOSHIBA DT01ACA1 + 500GB SAMSUNG HD501LJ + 120GB Western Digital WDS120G1G0A-MSI Intel Xeon E3-1200 v3/4th Gen Core IGP (1100MHz)Intel Xeon E3-1200 v3/4th4 x Intel 10-Gigabit X540-AT2 + Realtek RTL8111/8168/8411Ubuntu 20.046.7.3 (x86_64)GNOME Shell 3.36.9X Server 1.20.131.2.182GCC 9.4.0BcacheFSProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerVulkanCompilerFile-SystemSqlite1 BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-9QDOt0/gcc-9-9.4.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - MQ-DEADLINE / relatime,rw / Block Size: 512- Scaling Governor: intel_cpufreq performance - CPU Microcode: 0x28 - Thermald 1.9.1- gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: Not affected + 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 Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Not affected

bcachefs replica=3bcachefs replica=2bcachefs replica=1Result OverviewPhoronix Test Suite100%122%145%167%190%SQLiteSQLiteSQLite421

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: 4bcachefs replica=3bcachefs replica=2bcachefs replica=120406080100SE +/- 0.76, N = 13SE +/- 1.00, N = 3SE +/- 0.68, N = 15110.4176.7758.151. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 2bcachefs replica=3bcachefs replica=2bcachefs replica=11632486480SE +/- 0.55, N = 12SE +/- 0.39, N = 3SE +/- 0.55, N = 373.6960.2050.621. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 1bcachefs replica=3bcachefs replica=2bcachefs replica=11122334455SE +/- 0.70, N = 15SE +/- 0.87, N = 15SE +/- 0.04, N = 349.2841.8035.101. (CC) gcc options: -O2 -lz -lm -ldl -lpthread