sql

SQL

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1903096-SP-SQL89334125
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
SQL
March 09 2019
  1 Minute


sqlOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-2500K @ 3.70GHz (4 Cores)Gigabyte Z68X-UD3H-B3 (F12 BIOS)Intel 2nd Generation Core Family DRAM16384MB80GB INTEL SSDSA2CW08 + 8GB USB 2.0 FD + 128GB M4-CT128M4SSD2 + 3 x 2000GB Hitachi HDS5C302 + 500GB CT500MX500SSD1 + 256GB Crucial_CT256MX1Intel 2nd Generation Core Family IGP (1100MHz)Realtek ALC889D3218HN + DELL U2711Realtek RTL8111/8168/8411Ubuntu 18.044.18.0-16-generic (x86_64)GNOME Shell 3.28.3X Server 1.20.1modesetting 1.20.1GCC 7.3.0ext43840x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverCompilerFile-SystemScreen ResolutionSql BenchmarksSystem Logs- --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 - CFQ / errors=remount-ro,relatime,rw- Scaling Governor: intel_pstate powersave- KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + SSB disabled via prctl and seccomp + PTE Inversion; VMX: conditional cache flushes SMT disabled

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 InsertionsSQL48121620SE +/- 0.01, N = 315.661. (CC) gcc options: -O2 -ldl -lpthread