Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
SVT-AV1
7-Zip Compression
Stockfish
x265
FFmpeg
Newest Tests
LiteRT
WarpX
Epoch
Valkey
Whisperfile
XNNPACK
Recently Updated Tests
ASTC Encoder
SVT-AV1
Unvanquished
Primesieve
XNNPACK
oneDNN
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 1.9.0
pts/sqlite-1.9.0
- 09 June 2015 -
Big update to SQLite
downloads.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v5.8.0 (Belev)--> <PhoronixTestSuite> <Downloads> <Package> <URL>https://www.sqlite.org/2015/sqlite-autoconf-3081002.tar.gz</URL> <MD5>a18bfc015cd49a1e7a961b7b77bc3b37</MD5> <SHA256>8382e55a4e7d853c93038562ca3dd00307937fccf1c6b65ddd813e503a56d626</SHA256> <FileSize>2049387</FileSize> </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> <FileSize>42835</FileSize> </Package> </Downloads> </PhoronixTestSuite>
install.sh
#!/bin/sh tar -zxvf pts-sqlite-tests-1.tar.gz tar -zxvf sqlite-autoconf-3081002.tar.gz mkdir sqlite_/ cd sqlite-autoconf-3081002/ ./configure --prefix=$HOME/sqlite_/ make echo $? > ~/install-exit-status make install cd .. rm -rf sqlite-autoconf-3081002/ echo "#!/bin/sh if [ \"X\$@\" = \"X\" ] then TEST_PATH=\`pwd\` else TEST_PATH=\$@ fi cat sqlite-2500-insertions.txt > \$TEST_PATH/sqlite-insertions.txt ./sqlite_/bin/sqlite3 \$TEST_PATH/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 \$TEST_PATH/sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db cat \$TEST_PATH/sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db cat \$TEST_PATH/sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db" > sqlite-benchmark chmod +x sqlite-benchmark
interim.sh
#!/bin/sh if [ "X$@" = "X" ] then TEST_PATH=`pwd` else TEST_PATH=$@ fi rm -f $TEST_PATH/benchmark.db
post.sh
#!/bin/sh if [ "X$@" = "X" ] then TEST_PATH=`pwd` else TEST_PATH=$@ fi rm -f $TEST_PATH/benchmark.db
pre.sh
#!/bin/sh if [ "X$@" = "X" ] then TEST_PATH=`pwd` else TEST_PATH=$@ fi rm -f $TEST_PATH/benchmark.db
results-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v5.8.0 (Belev)--> <PhoronixTestSuite> <SystemMonitor> <Sensor>sys.time</Sensor> </SystemMonitor> </PhoronixTestSuite>
test-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v5.8.0 (Belev)--> <PhoronixTestSuite> <TestInformation> <Title>SQLite</Title> <AppVersion>3.8.10.2</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>1.9.0</Version> <SupportedPlatforms>Linux, BSD, MacOSX, Solaris</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> <TestSettings> <Option> <DisplayName>Test Target</DisplayName> <Identifier>auto-disk-mount-points</Identifier> <DefaultEntry>0</DefaultEntry> </Option> </TestSettings> </PhoronixTestSuite>