From 1a57267a17c2fc17fb6e104846fabc3e363c326c Mon Sep 17 00:00:00 2001
From: Emile <git@emile.space>
Date: Fri, 16 Aug 2024 19:50:26 +0200
Subject: initial commit

---
 vendor/modernc.org/sqlite/tpch.sh | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 vendor/modernc.org/sqlite/tpch.sh

(limited to 'vendor/modernc.org/sqlite/tpch.sh')

diff --git a/vendor/modernc.org/sqlite/tpch.sh b/vendor/modernc.org/sqlite/tpch.sh
new file mode 100644
index 0000000..46037bf
--- /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
-- 
cgit 1.4.1