From 16c616010a0e7e3a000abd951f386ffe1c6d9c6c Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 6 Feb 2023 15:52:38 +0100 Subject: Create some indexes on tags and references As this will speed up removing narinfos. --- nar-herder/database.scm | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'nar-herder/database.scm') diff --git a/nar-herder/database.scm b/nar-herder/database.scm index 1417c24..183966e 100644 --- a/nar-herder/database.scm +++ b/nar-herder/database.scm @@ -181,6 +181,16 @@ CREATE TABLE cached_narinfo_files ( CREATE INDEX cached_narinfo_files_narinfo_id ON cached_narinfo_files (narinfo_id);")) + (sqlite-exec + db + "CREATE INDEX IF NOT EXISTS narinfo_tags_narinfo_id + ON narinfo_tags (narinfo_id);") + + (sqlite-exec + db + "CREATE INDEX IF NOT EXISTS narinfo_references_narinfo_id + ON narinfo_references (narinfo_id);") + (sqlite-exec db "CREATE INDEX IF NOT EXISTS narinfo_files_narinfo_id -- cgit v1.2.3