Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/buildmaster
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-11-20 12:14:27 +0100
committerErich Eckner <git@eckner.net>2019-11-20 12:14:27 +0100
commit8414e9fde067bef257f1d788380aa61e838e87ca (patch)
tree4a07fc7da24616ea01c2311e702b26c381934cb9 /buildmaster
parent656e064fc19323eeef69e767b2475aeb3b42f6f7 (diff)
buildmaster/build-list.php: limit to 100 lines to accellerate query
Diffstat (limited to 'buildmaster')
-rw-r--r--buildmaster/build-list.php9
1 files changed, 6 insertions, 3 deletions
diff --git a/buildmaster/build-list.php b/buildmaster/build-list.php
index 7258a47..5222308 100644
--- a/buildmaster/build-list.php
+++ b/buildmaster/build-list.php
@@ -324,7 +324,9 @@ mysql_run_query(
mysql_join_build_assignments_binary_packages() .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
- ' WHERE `repositories`.`name`="build-list"'
+ ' WHERE `repositories`.`name`="build-list"' .
+ ' ORDER BY `build_assignments`.`currently_blocking` DESC' .
+ ' LIMIT 100'
);
mysql_run_query(
@@ -340,9 +342,9 @@ mysql_run_query(
'SELECT' .
' `dependent_bp`.`build_assignment`,' .
'COUNT(DISTINCT `dependency_bp`.`build_assignment`)' .
- ' FROM `binary_packages` AS `dependent_bp`' .
// only consider ba_q build assignments!
- mysql_join_binary_packages_build_assignments('dependent_bp','ba_q') .
+ ' FROM `ba_q`' .
+ mysql_join_build_assignments_binary_packages('ba_q','dependent_bp') .
mysql_join_binary_packages_dependencies('dependent_bp') .
mysql_join_dependencies_dependency_types() .
mysql_join_dependencies_install_target_providers() .
@@ -420,6 +422,7 @@ mysql_run_query(
'COUNT(1)' .
' FROM `build_dependency_loops`' .
// no need to filter for ba_q build assignments: only *those* can be in loops anyways
+ mysql_join_build_dependency_loops_build_assignments('','ba_q') .
' GROUP BY `build_dependency_loops`.`build_assignment`'
);