summaryrefslogtreecommitdiffstats
path: root/pts/test-resources/sqlite
diff options
context:
space:
mode:
authorMichael Larabel <michael@phx-laptop.(none)>2008-10-29 15:12:11 -0400
committerMichael Larabel <michael@phx-laptop.(none)>2008-10-29 15:12:11 -0400
commit0c2d99b817d0c8095ae333f00667d5669528dfb1 (patch)
tree5ad7598e2f4684bf306f0787c9fb759c1452c5f3 /pts/test-resources/sqlite
parent9ed07bb795fcaac5ba68f8f23f7a3041c0002389 (diff)
downloadphoronix-test-suite-upstream-0c2d99b817d0c8095ae333f00667d5669528dfb1.tar.gz
phoronix-test-suite-upstream-0c2d99b817d0c8095ae333f00667d5669528dfb1.tar.xz
phoronix-test-suite-upstream-0c2d99b817d0c8095ae333f00667d5669528dfb1.zip
pts: Update insertion count to 12,500 for sqlite test profile
Diffstat (limited to 'pts/test-resources/sqlite')
-rwxr-xr-xpts/test-resources/sqlite/install.sh6
1 files changed, 5 insertions, 1 deletions
diff --git a/pts/test-resources/sqlite/install.sh b/pts/test-resources/sqlite/install.sh
index 2f17a82..4cc1296 100755
--- a/pts/test-resources/sqlite/install.sh
+++ b/pts/test-resources/sqlite/install.sh
@@ -9,12 +9,16 @@ make -j $NUM_CPU_JOBS
cd ..
echo "#!/bin/sh
+cat sqlite-2500-insertions.txt | ./sqlite-3.6.3/sqlite3 benchmark.db
+cat sqlite-2500-insertions.txt | ./sqlite-3.6.3/sqlite3 benchmark.db
+cat sqlite-2500-insertions.txt | ./sqlite-3.6.3/sqlite3 benchmark.db
+cat sqlite-2500-insertions.txt | ./sqlite-3.6.3/sqlite3 benchmark.db
cat sqlite-2500-insertions.txt | ./sqlite-3.6.3/sqlite3 benchmark.db" > sqlite-inserts
chmod +x sqlite-inserts
echo "#!/bin/sh
rm -f benchmark.db
-./sqlite-3.6.3/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, PRIMARY KEY ('I'), UNIQUE ('I'));\"
+./sqlite-3.6.3/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);\"
\$TIMER_START
./sqlite-inserts 2>&1
\$TIMER_STOP