blob: 46037bfbf3d94d17292d8873ca7b87b653c58fc0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
set -e
echo "See http://www.tpc.org/tpc_documents_current_versions/pdf/tpc-h_v2.17.1.pdf for details"
tmp=$(mktemp -d)
cd $tmp
echo "installing modernc.org/sqlite/tpch@latest into $tmp"
GOBIN=$tmp go install modernc.org/sqlite/tpch@latest
echo "generating pseudotext"
./tpch -pseudotext
for sf in 1 10 ; do
for sut in sqlite3 sqlite ; do
echo "$sut: generating a $sf GB test DB"
time -p ./tpch -sut $sut -dbgen -sf $sf
for q in 1 2 ; do
echo -n "$sut: running query $q: "
./tpch -sut $sut -q $q -sf $sf
done
done
done
cd -
rm -rf $tmp
|
