diff options
author | Christopher Baines <mail@cbaines.net> | 2023-02-06 15:52:38 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2023-02-06 15:52:38 +0100 |
commit | 16c616010a0e7e3a000abd951f386ffe1c6d9c6c (patch) | |
tree | b4b1f7608b31c98c503a88da21b97bcb0a1755ed /nar-herder/database.scm | |
parent | 562ac009b7ee14f634f384f75468be8ebbac9ce6 (diff) | |
download | nar-herder-16c616010a0e7e3a000abd951f386ffe1c6d9c6c.tar nar-herder-16c616010a0e7e3a000abd951f386ffe1c6d9c6c.tar.gz |
Create some indexes on tags and references
As this will speed up removing narinfos.
Diffstat (limited to 'nar-herder/database.scm')
-rw-r--r-- | nar-herder/database.scm | 10 |
1 files changed, 10 insertions, 0 deletions
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 @@ -183,6 +183,16 @@ CREATE INDEX 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 ON narinfo_files (narinfo_id);")) |