From d230fdf22ba4e063b616f2e7a00c36ffa040d754 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Mon, 3 Dec 2018 06:53:55 +0000 Subject: [PATCH] add index on configuration files --- db.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/db.sql b/db.sql index a4a0651..42eeb06 100644 --- a/db.sql +++ b/db.sql @@ -171,6 +171,7 @@ without rowid create index packagefile_package_index on packagefiles (package); create index packagefile_path_index on packagefiles (path); create index packagefile_hash_index on packagefiles (hash); +create index pkgfile_configuration on packagefiles (configuration) where configuration = 1; create view packagefiles_pkgid as select printf('%s-%s-%s', package, version, release) as pkgid, *, -- 2.40.0