buildmaster/build-list.php: limit to 100 lines to accellerate query

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`'
 );