Add some more indexes to speed up derivation ordered allocation

3 files changed, 22 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/more_indexes_on_builds_and_derivation_inputs.sql b/sqitch/sqlite/deploy/more_indexes_on_builds_and_derivation_inputs.sql
new file mode 100644
index 0000000..5f2315b
--- /dev/null
+++ b/sqitch/sqlite/deploy/more_indexes_on_builds_and_derivation_inputs.sql
@@ -0,0 +1,8 @@
+-- Deploy guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs to sqlite
+
+BEGIN;
+
+CREATE INDEX derivation_inputs_derivation_output_id ON derivation_inputs (derivation_output_id);
+CREATE INDEX builds_unprocessed ON builds (processed) WHERE processed = 0;
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/more_indexes_on_builds_and_derivation_inputs.sql b/sqitch/sqlite/revert/more_indexes_on_builds_and_derivation_inputs.sql
new file mode 100644
index 0000000..22d6658
--- /dev/null
+++ b/sqitch/sqlite/revert/more_indexes_on_builds_and_derivation_inputs.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/more_indexes_on_builds_and_derivation_inputs.sql b/sqitch/sqlite/verify/more_indexes_on_builds_and_derivation_inputs.sql
new file mode 100644
index 0000000..b9dcbe1
--- /dev/null
+++ b/sqitch/sqlite/verify/more_indexes_on_builds_and_derivation_inputs.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:more_indexes_on_builds_and_derivation_inputs on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;