SQLite 1.8.0

pts/sqlite-1.8.0 - 06 December 2010 - Initial import into OpenBenchmarking.org

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v3.0.0a3 (Iveland) [ http://www.phoronix-test-suite.com/ ]-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>http://www.sqlite.org/sqlite-amalgamation-3.7.3.tar.gz</URL>
      <MD5>74fe78b264f1c434c4b159d45b78e9b7</MD5>
      <FileSize>1512409</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-amalgamation-3.7.3.tar.gz
mkdir sqlite_/

cd sqlite-3.7.3/
./configure --prefix=$HOME/sqlite_/
make
echo $? > ~/install-exit-status
make install
cd ..
rm -rf sqlite-3.7.3/
rm -rf sqlite_/lib/

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
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 v3.0.0a3 (Iveland) [ http://www.phoronix-test-suite.com/ ]-->
<PhoronixTestSuite>
  <SystemMonitor>
    <Sensor>sys.time</Sensor>
  </SystemMonitor>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v3.0.0a3 (Iveland) [ http://www.phoronix-test-suite.com/ ]-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>SQLite</Title>
    <AppVersion>3.7.3</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>12,500 INSERTs</SubTitle>
    <Executable>sqlite-benchmark</Executable>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.8.0</Version>
    <SupportedPlatforms>Linux, Solaris</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>Disk</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <ExternalDependencies>build-utilities</ExternalDependencies>
    <EnvironmentSize>18.4</EnvironmentSize>
    <ProjectURL>http://www.sqlite.org/</ProjectURL>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
  <TestSettings>
    <Option>
      <DisplayName>Test Target</DisplayName>
      <Identifier>auto-disk-mount-points</Identifier>
    </Option>
  </TestSettings>
</PhoronixTestSuite>