Replace datastore-fetch-input-builds-for-unprocessed-builds

It worked under some database conditions, but was very slow under others. Move
more of the logic in to SQL in an attempt to make the allocator faster. This
sort of works, but there were some advantages to the approach before the
approach being replaced in this commit.

1 files changed, 7 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/build_results_result_index.sql b/sqitch/sqlite/deploy/build_results_result_index.sql
new file mode 100644
index 0000000..00dfe33
--- /dev/null
+++ b/sqitch/sqlite/deploy/build_results_result_index.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:build_results_result_index to sqlite
+
+BEGIN;
+
+CREATE INDEX build_results_result_idx ON build_results (result);
+
+COMMIT;