Sqlite Test LFS 8.4 Vs Debian 9.9

SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1908119-HV-1908107HV99
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
LFS 8.4
August 10 2019
  2 Minutes
Debian 9.9
August 10 2019
  1 Minute
Debian 9.9 v4.9.0
August 11 2019
  2 Minutes
Invert Hiding All Results Option
  2 Minutes

Only show results where is faster than

LFS 8.4

Processor: AMD Ryzen 3 2200G (4 Cores), Motherboard: Oracle VirtualBox v1.2, Memory: 2048MB, Disk: 69GB VBOX HDD

OS: Linux From Scratch 8.4, Kernel: 4.20.12 (x86_64), Compiler: GCC 8.2.0, File-System: ext4, System Layer: VirtualBox

Compiler Notes: --disable-bootstrap --disable-libmpx --disable-multilib --enable-languages=c,c++
Disk Notes: MQ-DEADLINE / relatime,rw
Security Notes: l1tf: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

Debian 9.9

Processor: AMD Ryzen 3 2200G (4 Cores), Motherboard: Oracle VirtualBox v1.2, Chipset: + ICH7-M, Memory: 2048MB, Disk: 69GB VBOX HDD, Graphics: VMware SVGA II, Audio: Intel 82801AA AC 97 Audio, Network: Intel 82540EM

OS: Debian 9.9, Kernel: 4.20.12 (x86_64), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 2048x2048, System Layer: Oracle VMware

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v
Disk Notes: CFQ / errors=remount-ro,relatime,rw
Security Notes: l1tf: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

Debian 9.9 v4.9.0

OS: Debian 9.9, Kernel: 4.9.0-9-amd64 (x86_64), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 2048x2048, System Layer: Oracle VMware

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Security Notes: l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

Sqlite Test LFS 8.4 Vs Debian 9.9ProcessorMotherboardMemoryDiskChipsetGraphicsAudioNetworkOSKernelCompilerFile-SystemSystem LayerScreen ResolutionLFS 8.4Debian 9.9Debian 9.9 v4.9.0AMD Ryzen 3 2200G (4 Cores)Oracle VirtualBox v1.22048MB69GB VBOX HDDLinux From Scratch 8.44.20.12 (x86_64)GCC 8.2.0ext4VirtualBox+ ICH7-MVMware SVGA IIIntel 82801AA AC 97 AudioIntel 82540EMDebian 9.9GCC 6.3.0 201705162048x2048Oracle VMware4.9.0-9-amd64 (x86_64)OpenBenchmarking.orgCompiler Details- LFS 8.4: --disable-bootstrap --disable-libmpx --disable-multilib --enable-languages=c,c++ - Debian 9.9: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v - Debian 9.9 v4.9.0: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v Disk Details- LFS 8.4: MQ-DEADLINE / relatime,rw- Debian 9.9: CFQ / errors=remount-ro,relatime,rw- Debian 9.9 v4.9.0: CFQ / data=ordered,errors=remount-ro,relatime,rwSecurity Details- LFS 8.4: l1tf: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling - Debian 9.9: l1tf: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling - Debian 9.9 v4.9.0: l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

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 InsertionsLFS 8.4Debian 9.9Debian 9.9 v4.9.03691215SE +/- 0.10, N = 7SE +/- 0.07, N = 3SE +/- 0.19, N = 158.976.537.19-lreadline -lcurses -lz1. (CC) gcc options: -O2 -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.22Timed SQLite InsertionsLFS 8.4Debian 9.9Debian 9.9 v4.9.03691215Min: 8.74 / Avg: 8.97 / Max: 9.49Min: 6.42 / Avg: 6.53 / Max: 6.65Min: 6.33 / Avg: 7.19 / Max: 8.591. (CC) gcc options: -O2 -ldl -lpthread

LFS 8.4

Processor: AMD Ryzen 3 2200G (4 Cores), Motherboard: Oracle VirtualBox v1.2, Memory: 2048MB, Disk: 69GB VBOX HDD

OS: Linux From Scratch 8.4, Kernel: 4.20.12 (x86_64), Compiler: GCC 8.2.0, File-System: ext4, System Layer: VirtualBox

Compiler Notes: --disable-bootstrap --disable-libmpx --disable-multilib --enable-languages=c,c++
Disk Notes: MQ-DEADLINE / relatime,rw
Security Notes: l1tf: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

Testing initiated at 10 August 2019 13:57 by user root.

Debian 9.9

Processor: AMD Ryzen 3 2200G (4 Cores), Motherboard: Oracle VirtualBox v1.2, Chipset: + ICH7-M, Memory: 2048MB, Disk: 69GB VBOX HDD, Graphics: VMware SVGA II, Audio: Intel 82801AA AC 97 Audio, Network: Intel 82540EM

OS: Debian 9.9, Kernel: 4.20.12 (x86_64), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 2048x2048, System Layer: Oracle VMware

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v
Disk Notes: CFQ / errors=remount-ro,relatime,rw
Security Notes: l1tf: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

Testing initiated at 10 August 2019 22:29 by user root.

Debian 9.9 v4.9.0

Processor: AMD Ryzen 3 2200G (4 Cores), Motherboard: Oracle VirtualBox v1.2, Chipset: + ICH7-M, Memory: 2048MB, Disk: 69GB VBOX HDD, Graphics: VMware SVGA II, Audio: Intel 82801AA AC 97 Audio, Network: Intel 82540EM

OS: Debian 9.9, Kernel: 4.9.0-9-amd64 (x86_64), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 2048x2048, System Layer: Oracle VMware

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Security Notes: l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling

Testing initiated at 11 August 2019 12:04 by user irham.