summaryrefslogtreecommitdiffstats
path: root/vendor/modernc.org/sqlite/tpch.sh
diff options
context:
space:
mode:
authorWim <wim@42.be>2022-01-31 00:27:37 +0100
committerWim <wim@42.be>2022-03-20 14:57:48 +0100
commite3cafeaf9292f67459ff1d186f68283bfaedf2ae (patch)
treeb69c39620aa91dba695b3b935c6651c0fb37ce75 /vendor/modernc.org/sqlite/tpch.sh
parente7b193788a56ee7cdb02a87a9db0ad6724ef66d5 (diff)
downloadmatterbridge-msglm-e3cafeaf9292f67459ff1d186f68283bfaedf2ae.tar.gz
matterbridge-msglm-e3cafeaf9292f67459ff1d186f68283bfaedf2ae.tar.bz2
matterbridge-msglm-e3cafeaf9292f67459ff1d186f68283bfaedf2ae.zip
Add dependencies/vendor (whatsapp)
Diffstat (limited to 'vendor/modernc.org/sqlite/tpch.sh')
-rw-r--r--vendor/modernc.org/sqlite/tpch.sh20
1 files changed, 20 insertions, 0 deletions
diff --git a/vendor/modernc.org/sqlite/tpch.sh b/vendor/modernc.org/sqlite/tpch.sh
new file mode 100644
index 00000000..46037bfb
--- /dev/null
+++ b/vendor/modernc.org/sqlite/tpch.sh
@@ -0,0 +1,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