From 8414e9fde067bef257f1d788380aa61e838e87ca Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 20 Nov 2019 12:14:27 +0100 Subject: buildmaster/build-list.php: limit to 100 lines to accellerate query --- buildmaster/build-list.php | 9 ++++++--- 1 file 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`' ); -- cgit v1.2.3