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

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
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 Hiding All Results Option
  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):

bcachefs replica=3

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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
Disk Notes: MQ-DEADLINE / relatime,rw / Block Size: 512
Processor Notes: Scaling Governor: intel_cpufreq performance - CPU Microcode: 0x28 - Thermald 1.9.1
Security Notes: 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=2

bcachefs replica=1

Processor: Intel Core i5-4460 @ 3.40GHz (4 Cores), Motherboard: Mouse Z97-S01 v1.0 (V2.0B5 BIOS), Chipset: Intel 4th Gen Core DRAM, Memory: 2 x 8192 MB DDR3-1600MT/s, Disk: 2 x 1000GB TOSHIBA DT01ACA1 + 500GB SAMSUNG HD501LJ + 120GB Western Digital WDS120G1G0A-, Graphics: MSI Intel Xeon E3-1200 v3/4th Gen Core IGP (1100MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: 4 x Intel 10-Gigabit X540-AT2 + Realtek RTL8111/8168/8411

OS: Ubuntu 20.04, Kernel: 6.7.3 (x86_64), Desktop: GNOME Shell 3.36.9, Display Server: X Server 1.20.13, Vulkan: 1.2.182, Compiler: GCC 9.4.0, File-System: BcacheFS

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: 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
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 1bcachefs replica=3bcachefs replica=2bcachefs replica=11020304050Min: 46.13 / Avg: 49.28 / Max: 57.79Min: 38.78 / Avg: 41.8 / Max: 52.75Min: 35.04 / Avg: 35.1 / Max: 35.171. (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: 2bcachefs replica=3bcachefs replica=2bcachefs replica=11428425670Min: 70.2 / Avg: 73.69 / Max: 78.18Min: 59.45 / Avg: 60.2 / Max: 60.76Min: 49.85 / Avg: 50.62 / Max: 51.691. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

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: 4bcachefs replica=3bcachefs replica=2bcachefs replica=120406080100Min: 105.37 / Avg: 110.41 / Max: 113.56Min: 75.49 / Avg: 76.77 / Max: 78.75Min: 54.68 / Avg: 58.15 / Max: 63.761. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

bcachefs replica=3

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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
Disk Notes: MQ-DEADLINE / relatime,rw / Block Size: 512
Processor Notes: Scaling Governor: intel_cpufreq performance - CPU Microcode: 0x28 - Thermald 1.9.1
Security Notes: 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

Testing initiated at 18 March 2024 16:16 by user root.

bcachefs replica=2

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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
Disk Notes: MQ-DEADLINE / relatime,rw / Block Size: 512
Processor Notes: Scaling Governor: intel_cpufreq performance - CPU Microcode: 0x28 - Thermald 1.9.1
Security Notes: 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

Testing initiated at 18 March 2024 18:21 by user root.

bcachefs replica=1

Processor: Intel Core i5-4460 @ 3.40GHz (4 Cores), Motherboard: Mouse Z97-S01 v1.0 (V2.0B5 BIOS), Chipset: Intel 4th Gen Core DRAM, Memory: 2 x 8192 MB DDR3-1600MT/s, Disk: 2 x 1000GB TOSHIBA DT01ACA1 + 500GB SAMSUNG HD501LJ + 120GB Western Digital WDS120G1G0A-, Graphics: MSI Intel Xeon E3-1200 v3/4th Gen Core IGP (1100MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: 4 x Intel 10-Gigabit X540-AT2 + Realtek RTL8111/8168/8411

OS: Ubuntu 20.04, Kernel: 6.7.3 (x86_64), Desktop: GNOME Shell 3.36.9, Display Server: X Server 1.20.13, Vulkan: 1.2.182, Compiler: GCC 9.4.0, File-System: BcacheFS

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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
Disk Notes: MQ-DEADLINE / relatime,rw / Block Size: 512
Processor Notes: Scaling Governor: intel_cpufreq performance - CPU Microcode: 0x28 - Thermald 1.9.1
Security Notes: 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

Testing initiated at 18 March 2024 19:09 by user root.