blob: a720db7d7d63370f8f09ca50739e0ddbb1d9e9bc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
#!/bin/sh
tar -xvf pts-sqlite-tests-1.tar.gz
tar -xvf sqlite-3.6.6.2.tar.gz
mv sqlite-3.6.6.2/ sqlite_env/
cd sqlite_env/
./configure
make -j $NUM_CPU_JOBS
cd ..
echo "#!/bin/sh
cat sqlite-2500-insertions.txt | ./sqlite_env/sqlite3 benchmark.db
cat sqlite-2500-insertions.txt | ./sqlite_env/sqlite3 benchmark.db
cat sqlite-2500-insertions.txt | ./sqlite_env/sqlite3 benchmark.db
cat sqlite-2500-insertions.txt | ./sqlite_env/sqlite3 benchmark.db
cat sqlite-2500-insertions.txt | ./sqlite_env/sqlite3 benchmark.db" > sqlite-inserts
chmod +x sqlite-inserts
echo "#!/bin/sh
rm -f benchmark.db
./sqlite_env/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
rm -f benchmark.db" > sqlite-benchmark
chmod +x sqlite-benchmark
|