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.

HTML result view exported from: https://openbenchmarking.org/result/1908119-HV-1908107HV99.

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 Test LFS 8.4 Vs Debian 9.9sqlite: Timed SQLite InsertionsDifferenceStandard ErrorStandard DeviationLFS 8.4Debian 9.9Debian 9.9 v4.9.08.971.00x0.102.84%6.531.27x0.071.77%7.191.20x0.1910.20%OpenBenchmarking.org

SQLite

Timed SQLite Insertions

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

Phoronix Test Suite v10.8.4