sqlite01

GUI TEST

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1603201-KH-SQLITE01287
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
Disable Color Branding
Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
sqlite01
March 20 2016
 
sqlite02
March 20 2016
 
ASUS NVIDIA GeForce GTX 560
March 20 2016
 
SQLITE03
March 20 2016
 
Invert Hiding All Results Option
 

Only show results where is faster than

sqlite01

Processor: Intel Core i7-2600K @ 3.80GHz (8 Cores), Motherboard: ASUS P8Z68-V LX, Chipset: Intel 2nd Generation Core Family DRAM, Memory: 20480MB, Disk: 2 x 1500GB Seagate ST31500341AS + 60GB Patriot Pyro, Graphics: ASUS NVIDIA GeForce GTX 560 1024MB (50/135MHz), Audio: Realtek ALC887-VD, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 15.10, Kernel: 4.2.0-34-generic (x86_64), Desktop: Xfce 4.12, Display Server: X Server 1.17.2, Display Driver: NVIDIA 352.63, OpenGL: 4.4.0, Compiler: GCC 5.2.1 20151010, File-System: ext4, Screen Resolution: 1920x1080

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: CFQ.

sqlite02

ASUS NVIDIA GeForce GTX 560

SQLITE03

Changed Graphics to ASUS NVIDIA GeForce GTX 560 1024MB (810/2004MHz).

sqlite01OpenBenchmarking.orgPhoronix Test SuiteIntel Core i7-2600K @ 3.80GHz (8 Cores)ASUS P8Z68-V LXIntel 2nd Generation Core Family DRAM20480MB2 x 1500GB Seagate ST31500341AS + 60GB Patriot PyroASUS NVIDIA GeForce GTX 560 1024MB (50/135MHz)ASUS NVIDIA GeForce GTX 560 1024MB (810/2004MHz)Realtek ALC887-VDRealtek RTL8111/8168/8411Ubuntu 15.104.2.0-34-generic (x86_64)Xfce 4.12X Server 1.17.2NVIDIA 352.634.4.0GCC 5.2.1 20151010ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionSqlite01 BenchmarksSystem Logs- --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - CFQ / data=ordered,errors=remount-ro,relatime,rw- Scaling Governor: intel_pstate powersave- Disk Scheduler: CFQ.

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.8.10.2Test Target: Default Test Directorysqlite01sqlite02ASUS NVIDIA GeForce GTX 560SQLITE0348121620SE +/- 0.01, N = 3SE +/- 0.02, N = 3SE +/- 0.09, N = 3SE +/- 0.01, N = 314.2814.7114.8615.301. (CC) gcc options: -O2 -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.8.10.2Test Target: Default Test Directorysqlite01sqlite02ASUS NVIDIA GeForce GTX 560SQLITE0348121620Min: 14.27 / Avg: 14.28 / Max: 14.3Min: 14.67 / Avg: 14.71 / Max: 14.73Min: 14.7 / Avg: 14.86 / Max: 15Min: 15.29 / Avg: 15.3 / Max: 15.321. (CC) gcc options: -O2 -ldl -lpthread

sqlite01

Processor: Intel Core i7-2600K @ 3.80GHz (8 Cores), Motherboard: ASUS P8Z68-V LX, Chipset: Intel 2nd Generation Core Family DRAM, Memory: 20480MB, Disk: 2 x 1500GB Seagate ST31500341AS + 60GB Patriot Pyro, Graphics: ASUS NVIDIA GeForce GTX 560 1024MB (50/135MHz), Audio: Realtek ALC887-VD, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 15.10, Kernel: 4.2.0-34-generic (x86_64), Desktop: Xfce 4.12, Display Server: X Server 1.17.2, Display Driver: NVIDIA 352.63, OpenGL: 4.4.0, Compiler: GCC 5.2.1 20151010, File-System: ext4, Screen Resolution: 1920x1080

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: CFQ.

Testing initiated at 20 March 2016 10:25 by user j.

sqlite02

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: CFQ.

Testing initiated at 20 March 2016 10:40 by user j.

ASUS NVIDIA GeForce GTX 560

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: CFQ.

Testing initiated at 20 March 2016 10:50 by user j.

SQLITE03

Processor: Intel Core i7-2600K @ 3.80GHz (8 Cores), Motherboard: ASUS P8Z68-V LX, Chipset: Intel 2nd Generation Core Family DRAM, Memory: 20480MB, Disk: 2 x 1500GB Seagate ST31500341AS + 60GB Patriot Pyro, Graphics: ASUS NVIDIA GeForce GTX 560 1024MB (810/2004MHz), Audio: Realtek ALC887-VD, Network: Realtek RTL8111/8168/8411

OS: Ubuntu 15.10, Kernel: 4.2.0-34-generic (x86_64), Desktop: Xfce 4.12, Display Server: X Server 1.17.2, Display Driver: NVIDIA 352.63, OpenGL: 4.4.0, Compiler: GCC 5.2.1 20151010, File-System: ext4, Screen Resolution: 1920x1080

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: CFQ.

Testing initiated at 20 March 2016 11:28 by user j.