aboutsummaryrefslogtreecommitdiff
path: root/sqitch/sqlite/revert/build_counts.sql
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2022-10-28 11:50:45 +0100
committerChristopher Baines <mail@cbaines.net>2022-10-28 11:50:45 +0100
commit3768aec91daebb8db58e28cffe481e8878b59700 (patch)
tree11b5715086b077bd3d7b80eb85cb3285a54bffe1 /sqitch/sqlite/revert/build_counts.sql
parent6cd8bd854332301edef6eee68080881b8349d768 (diff)
downloadbuild-coordinator-3768aec91daebb8db58e28cffe481e8878b59700.tar
build-coordinator-3768aec91daebb8db58e28cffe481e8878b59700.tar.gz
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.
Diffstat (limited to 'sqitch/sqlite/revert/build_counts.sql')
-rw-r--r--sqitch/sqlite/revert/build_counts.sql7
1 files changed, 7 insertions, 0 deletions
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;