From 3768aec91daebb8db58e28cffe481e8878b59700 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 28 Oct 2022 11:50:45 +0100 Subject: Store build and build results counts in the database Rather than trying to count all builds and build results at startup. This should speed up the coordinator starting up, as currently it gets slower the more builds and build results are in the database. --- sqitch/sqlite/revert/build_counts.sql | 7 +++++++ sqitch/sqlite/revert/build_results_counts.sql | 7 +++++++ 2 files changed, 14 insertions(+) create mode 100644 sqitch/sqlite/revert/build_counts.sql create mode 100644 sqitch/sqlite/revert/build_results_counts.sql (limited to 'sqitch/sqlite/revert') diff --git a/sqitch/sqlite/revert/build_counts.sql b/sqitch/sqlite/revert/build_counts.sql new file mode 100644 index 0000000..232f813 --- /dev/null +++ b/sqitch/sqlite/revert/build_counts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_counts from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/revert/build_results_counts.sql b/sqitch/sqlite/revert/build_results_counts.sql new file mode 100644 index 0000000..ed4338a --- /dev/null +++ b/sqitch/sqlite/revert/build_results_counts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_results_counts from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; -- cgit v1.2.3