sqll

sqlit

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2206159-NE-SQLL2419235
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
sqlll
June 15 2022
  10 Hours, 20 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):

sqlll

Processor: Intel Xeon E3-1505M v6 (4 Cores / 8 Threads), Motherboard: Dell 06X96V (1.28.0 BIOS), Chipset: Intel Xeon E3-1200 v6/7th, Memory: 32GB, Disk: 1000GB Samsung SSD 970 EVO 1TB, Graphics: NVIDIA Quadro M1200 4GB, Audio: Realtek ALC3266, Network: Intel 8265 / 8275

OS: Ubuntu 20.04, Kernel: 5.17.0-15.1-liquorix-amd64 (x86_64), Desktop: GNOME Shell 3.36.9, Display Server: X Server 1.20.9, Display Driver: NVIDIA 510.73.05, OpenGL: 4.6.0, OpenCL: OpenCL 3.0 CUDA 11.6.134, Vulkan: 1.3.194, Compiler: GCC 9.4.0, File-System: ext4, Screen Resolution: 1920x1080

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-Av3uEd/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: BFQ / errors=remount-ro,relatime,rw / Block Size: 4096
Processor Notes: CPU Microcode: 0xf0 - Thermald 1.9.1
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + 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: conditional RSB filling + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled

sqllOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon E3-1505M v6 (4 Cores / 8 Threads)Dell 06X96V (1.28.0 BIOS)Intel Xeon E3-1200 v6/7th32GB1000GB Samsung SSD 970 EVO 1TBNVIDIA Quadro M1200 4GBRealtek ALC3266Intel 8265 / 8275Ubuntu 20.045.17.0-15.1-liquorix-amd64 (x86_64)GNOME Shell 3.36.9X Server 1.20.9NVIDIA 510.73.054.6.0OpenCL 3.0 CUDA 11.6.1341.3.194GCC 9.4.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLOpenCLVulkanCompilerFile-SystemScreen ResolutionSqll 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-Av3uEd/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 - BFQ / errors=remount-ro,relatime,rw / Block Size: 4096- CPU Microcode: 0xf0 - Thermald 1.9.1- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + 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: conditional RSB filling + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled

sqllsqlite: 1sqlite: 8sqlite: 32sqlite: 64sqlite: 128sqlll40.850443.2971688.2873209.3895933.113OpenBenchmarking.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. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1sqlll918273645SE +/- 0.15, N = 340.851. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8sqlll100200300400500SE +/- 5.98, N = 3443.301. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32sqlll400800120016002000SE +/- 11.28, N = 31688.291. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 64sqlll7001400210028003500SE +/- 36.25, N = 43209.391. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 128sqlll13002600390052006500SE +/- 10.85, N = 35933.111. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

sqlll

Processor: Intel Xeon E3-1505M v6 (4 Cores / 8 Threads), Motherboard: Dell 06X96V (1.28.0 BIOS), Chipset: Intel Xeon E3-1200 v6/7th, Memory: 32GB, Disk: 1000GB Samsung SSD 970 EVO 1TB, Graphics: NVIDIA Quadro M1200 4GB, Audio: Realtek ALC3266, Network: Intel 8265 / 8275

OS: Ubuntu 20.04, Kernel: 5.17.0-15.1-liquorix-amd64 (x86_64), Desktop: GNOME Shell 3.36.9, Display Server: X Server 1.20.9, Display Driver: NVIDIA 510.73.05, OpenGL: 4.6.0, OpenCL: OpenCL 3.0 CUDA 11.6.134, Vulkan: 1.3.194, Compiler: GCC 9.4.0, File-System: ext4, Screen Resolution: 1920x1080

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-Av3uEd/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: BFQ / errors=remount-ro,relatime,rw / Block Size: 4096
Processor Notes: CPU Microcode: 0xf0 - Thermald 1.9.1
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + 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: conditional RSB filling + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled

Testing initiated at 15 June 2022 14:21 by user sams.