sqliteTest1

SQlite benchmark on ubuntu 18.04 proxmox

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1811214-KH-1810164FO03
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

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
sqliteTest1
October 17 2018
 
CCxcp
November 21 2018
 
Invert Hiding All Results Option
 

sqliteTest1

Processor: 2 x Common KVM @ 2.20GHz (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Chipset: Intel 440FX- 82441FX PMC, Memory: 4608MB, Disk: 34GB QEMU HDD, Network: Red Hat Virtio device

OS: Ubuntu 18.04, Kernel: 4.15.0-36-generic (x86_64), Compiler: GCC 7.3.0, File-System: ext4, System Layer: KVM

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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -v
Disk Notes: NONE / data=ordered,relatime,rw
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline Protection

CCxcp

Processor: 4 x Intel Core i7-3632QM @ 2.20GHz (8 Cores), Motherboard: Xen HVM domU, Chipset: Intel 440FX- 82441FX PMC, Memory: 4096MB, Disk: 10GB, Graphics: Device 1234:1111

OS: Ubuntu 18.04, Kernel: 4.15.0-39-generic (x86_64), File-System: ext4, System Layer: Xen HVM domU 4.7.6-6.2.1.xcp

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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -v
Disk Mount Options Notes: data=ordered,relatime,rw

sqliteTest1ProcessorMotherboardChipsetMemoryDiskNetworkGraphicsOSKernelCompilerFile-SystemSystem LayersqliteTest1CCxcp2 x Common KVM @ 2.20GHz (8 Cores)QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS)Intel 440FX- 82441FX PMC4608MB34GB QEMU HDDRed Hat Virtio deviceUbuntu 18.044.15.0-36-generic (x86_64)GCC 7.3.0ext4KVM4 x Intel Core i7-3632QM @ 2.20GHz (8 Cores)Xen HVM domU4096MB10GBDevice 1234:11114.15.0-39-generic (x86_64)Xen HVM domU 4.7.6-6.2.1.xcpOpenBenchmarking.orgCompiler Details- --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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -v Disk Details- sqliteTest1: NONE / data=ordered,relatime,rwSecurity Details- sqliteTest1: KPTI + __user pointer sanitization + Full generic retpoline ProtectionDisk Mount Options Details- CCxcp: data=ordered,relatime,rw

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.22Timed SQLite InsertionssqliteTest1CCxcp20406080100SE +/- 8.45, N = 6SE +/- 0.08, N = 392.237.531. (CC) gcc options: -O2 -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.22Timed SQLite InsertionssqliteTest1CCxcp20406080100Min: 61.33 / Avg: 92.23 / Max: 106.73Min: 7.4 / Avg: 7.53 / Max: 7.691. (CC) gcc options: -O2 -ldl -lpthread

sqliteTest1

Processor: 2 x Common KVM @ 2.20GHz (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Chipset: Intel 440FX- 82441FX PMC, Memory: 4608MB, Disk: 34GB QEMU HDD, Network: Red Hat Virtio device

OS: Ubuntu 18.04, Kernel: 4.15.0-36-generic (x86_64), Compiler: GCC 7.3.0, File-System: ext4, System Layer: KVM

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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -v
Disk Notes: NONE / data=ordered,relatime,rw
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline Protection

Testing initiated at 17 October 2018 01:50 by user axel.

CCxcp

Processor: 4 x Intel Core i7-3632QM @ 2.20GHz (8 Cores), Motherboard: Xen HVM domU, Chipset: Intel 440FX- 82441FX PMC, Memory: 4096MB, Disk: 10GB, Graphics: Device 1234:1111

OS: Ubuntu 18.04, Kernel: 4.15.0-39-generic (x86_64), File-System: ext4, System Layer: Xen HVM domU 4.7.6-6.2.1.xcp

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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -v
Disk Mount Options Notes: data=ordered,relatime,rw

Testing initiated at 21 November 2018 05:53 by user ubuntu.