Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
7-Zip Compression
SVT-AV1
FFmpeg
PostgreSQL
Stockfish
Newest Tests
WarpX
Epoch
Valkey
Whisperfile
XNNPACK
GROMACS
Recently Updated Tests
Apache CouchDB
PostgreSQL
NAMD
Apache Cassandra
Opus Codec Encoding
ParaView
New & Recently Updated Tests
Recently Updated Suites
Database Test Suite
Machine Learning
Steam
New & Recently Updated Suites
Component Benchmarks
CPUs / Processors
GPUs / Graphics
OpenGL
Disks / Storage
Motherboards
File-Systems
Operating Systems
OpenBenchmarking.org
Corporate / Organization Info
Bug Reports / Feature Requests
SQLite 2.0.1
pts/sqlite-2.0.1
- 28 February 2018 -
Add Windows support.
downloads.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v8.0.0m0--> <PhoronixTestSuite> <Downloads> <Package> <URL>http://sqlite.org/2018/sqlite-autoconf-3220000.tar.gz</URL> <MD5>96b5648d542e8afa6ab7ffb8db8ddc3d</MD5> <SHA256>2824ab1238b706bc66127320afbdffb096361130e23291f26928a027b885c612</SHA256> <FileSize>2644649</FileSize> </Package> <Package> <URL>http://sqlite.org/2018/sqlite-tools-win32-x86-3220000.zip</URL> <MD5>971ee1bba806f0077cbd413e8caed519</MD5> <SHA256>e318d482423913fc8439bc551362372b10234594cf6928bd927fed4c7e79dcbe</SHA256> <FileSize>1701584</FileSize> <PlatformSpecific>Windows</PlatformSpecific> </Package> <Package> <URL>http://www.phoronix-test-suite.com/benchmark-files/pts-sqlite-tests-1.tar.gz, http://www.phoronix.net/downloads/phoronix-test-suite/benchmark-files/pts-sqlite-tests-1.tar.gz</URL> <MD5>153e725642619e38766ddf8359f65cfe</MD5> <SHA256>1067f047461e21fd56e2a6ae03043c687047d00192ffdbe5b52271cd39de442f</SHA256> <FileSize>42835</FileSize> </Package> </Downloads> </PhoronixTestSuite>
install.sh
#!/bin/sh tar -zxvf pts-sqlite-tests-1.tar.gz tar -zxvf sqlite-autoconf-3220000.tar.gz mkdir sqlite_/ cd sqlite-autoconf-3220000/ ./configure --prefix=$HOME/sqlite_/ make echo $? > ~/install-exit-status make install cd .. rm -rf sqlite-autoconf-3220000/ echo "#!/bin/sh cat sqlite-2500-insertions.txt > sqlite-insertions.txt ./sqlite_/bin/sqlite3 benchmark.db \"CREATE TABLE pts1 ('I' SMALLINT NOT NULL, 'DT' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 'F1' VARCHAR(4) NOT NULL, 'F2' VARCHAR(16) NOT NULL);\" cat sqlite-insertions.txt | ./sqlite_/bin/sqlite3 benchmark.db cat sqlite-insertions.txt | ./sqlite_/bin/sqlite3 benchmark.db cat sqlite-insertions.txt | ./sqlite_/bin/sqlite3 benchmark.db" > sqlite-benchmark chmod +x sqlite-benchmark
install_windows.sh
#!/bin/sh tar -zxvf pts-sqlite-tests-1.tar.gz unzip -o sqlite-tools-win32-x86-3220000.zip echo "#!/bin/sh cat sqlite-2500-insertions.txt > sqlite-insertions.txt ./sqlite-tools-win32-x86-3220000/sqlite3.exe benchmark.db \"CREATE TABLE pts1 ('I' SMALLINT NOT NULL, 'DT' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 'F1' VARCHAR(4) NOT NULL, 'F2' VARCHAR(16) NOT NULL);\" cat sqlite-insertions.txt | ./sqlite-tools-win32-x86-3220000/sqlite3.exe benchmark.db cat sqlite-insertions.txt | ./sqlite-tools-win32-x86-3220000/sqlite3.exe benchmark.db cat sqlite-insertions.txt | ./sqlite-tools-win32-x86-3220000/sqlite3.exe benchmark.db" > sqlite-benchmark chmod +x sqlite-benchmark
interim.sh
#!/bin/sh rm -f benchmark.db
post.sh
#!/bin/sh rm -f benchmark.db
pre.sh
#!/bin/sh rm -f benchmark.db
results-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v8.0.0m0--> <PhoronixTestSuite> <SystemMonitor> <Sensor>sys.time</Sensor> </SystemMonitor> </PhoronixTestSuite>
test-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v8.0.0m0--> <PhoronixTestSuite> <TestInformation> <Title>SQLite</Title> <AppVersion>3.22</AppVersion> <Description>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.</Description> <ResultScale>Seconds</ResultScale> <Proportion>LIB</Proportion> <SubTitle>Timed SQLite Insertions</SubTitle> <Executable>sqlite-benchmark</Executable> <TimesToRun>3</TimesToRun> </TestInformation> <TestProfile> <Version>2.0.1</Version> <SupportedPlatforms>Linux, BSD, MacOSX, Solaris, Windows</SupportedPlatforms> <SoftwareType>Benchmark</SoftwareType> <TestType>Disk</TestType> <License>Free</License> <Status>Verified</Status> <ExternalDependencies>build-utilities</ExternalDependencies> <EnvironmentSize>22</EnvironmentSize> <ProjectURL>http://www.sqlite.org/</ProjectURL> <Maintainer>Michael Larabel</Maintainer> </TestProfile> </PhoronixTestSuite>