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