sqlite-2.2.0-result.txt

docker testing 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 2404217-NE-SQLITE22029
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
sqlite-2.2.0
April 21
  1 Hour, 49 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

Processor: 2 x AMD EPYC 7542 32-Core (64 Cores / 128 Threads), Motherboard: Dell PowerEdge R7525 0590KW (2.2.5 BIOS), Memory: 2016GB, Disk: 4 x 7682GB Dell Ent NVMe AGN RI U.2 7.68TB + 480GB DELLBOSS VD, Graphics: mgag200drmfb

OS: Ubuntu 20.04, Kernel: 5.4.0-42-generic (x86_64), Display Driver: NVIDIA, Vulkan: 1.1.182, Compiler: GCC 9.4.0 + CUDA 11.6, File-System: overlayfs, Screen Resolution: 1024x768, System Layer: docker

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
Processor Notes: CPU Microcode: 0x830104d
Disk Scheduler Notes: none
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

sqlite-2.2.0-result.txt OpenBenchmarking.orgPhoronix Test Suite2 x AMD EPYC 7542 32-Core (64 Cores / 128 Threads)Dell PowerEdge R7525 0590KW (2.2.5 BIOS)2016GB4 x 7682GB Dell Ent NVMe AGN RI U.2 7.68TB + 480GB DELLBOSS VDmgag200drmfbUbuntu 20.045.4.0-42-generic (x86_64)NVIDIA1.1.182GCC 9.4.0 + CUDA 11.6overlayfs1024x768dockerProcessorMotherboardMemoryDiskGraphicsOSKernelDisplay DriverVulkanCompilerFile-SystemScreen ResolutionSystem LayerSqlite-2.2.0-result.txt 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 - CPU Microcode: 0x830104d- none- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

sqlite-2.2.0-result.txt sqlite: 1sqlite: 2sqlite: 4sqlite: 8sqlite: 16sqlite: 32sqlite: 64sqlite: 128sqlite-2.2.04.0735.07110.71626.94975.588198.018482.9801222.471OpenBenchmarking.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.00.91641.83282.74923.66564.582SE +/- 0.045, N = 34.0731. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 2sqlite-2.2.01.1412.2823.4234.5645.705SE +/- 0.053, N = 35.0711. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 4sqlite-2.2.03691215SE +/- 0.07, N = 1510.721. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8sqlite-2.2.0612182430SE +/- 0.17, N = 1526.951. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16sqlite-2.2.020406080100SE +/- 1.02, N = 375.591. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 32sqlite-2.2.04080120160200SE +/- 0.62, N = 3198.021. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 64sqlite-2.2.0100200300400500SE +/- 1.42, N = 3482.981. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 128sqlite-2.2.030060090012001500SE +/- 7.57, N = 31222.471. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

8 Results Shown

SQLite:
  1
  2
  4
  8
  16
  32
  64
  128

sqlite-2.2.0

Processor: 2 x AMD EPYC 7542 32-Core (64 Cores / 128 Threads), Motherboard: Dell PowerEdge R7525 0590KW (2.2.5 BIOS), Memory: 2016GB, Disk: 4 x 7682GB Dell Ent NVMe AGN RI U.2 7.68TB + 480GB DELLBOSS VD, Graphics: mgag200drmfb

OS: Ubuntu 20.04, Kernel: 5.4.0-42-generic (x86_64), Display Driver: NVIDIA, Vulkan: 1.1.182, Compiler: GCC 9.4.0 + CUDA 11.6, File-System: overlayfs, Screen Resolution: 1024x768, System Layer: docker

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
Processor Notes: CPU Microcode: 0x830104d
Disk Scheduler Notes: none
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 21 April 2024 08:34 by user root.