gitlab.com/CoiaPrant/sqlite3@v1.19.1/tpch.sh (about)

     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 gitlab.com/CoiaPrant/sqlite3/tpch@latest into $tmp"
     6  GOBIN=$tmp go install gitlab.com/CoiaPrant/sqlite3/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