bin/get-assignment: accellerate query (?) by using temporary table instead of "WHERE EXISTS (SELECT ...)"

1 files changed, 6 insertions, 2 deletions

diff --git a/bin/get-assignment b/bin/get-assignment
index 9dcb600..44cfe66 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -219,6 +219,8 @@ next_building=$(
       printf ');\n'
     done
 
+    mysql_query_generate_packages_with_pending_dependencies
+
     printf 'INSERT IGNORE INTO `considered_build_assignments` (`id`)'
     printf ' SELECT `build_assignments`.`id`'
     printf ' FROM `build_assignments`'
@@ -240,6 +242,9 @@ next_building=$(
     printf ')'
     printf ' LEFT'
     mysql_join_package_sources_toolchain_order
+    printf ' LEFT JOIN `packages_with_pending_dependencies`'
+    printf ' ON `packages_with_pending_dependencies`.`builder_architecture`=`build_command_architectures`.`id`'
+    printf ' AND `packages_with_pending_dependencies`.`build_assignment`=`build_assignments`.`id`'
     printf ' WHERE ('
       printf '`build_assignments`.`is_blocked` IS NULL'
       if [ -n "${requested}" ]; then
@@ -249,8 +254,7 @@ next_building=$(
       fi
     printf ') AND ('
       mysql_query_is_part_of_loop '`build_assignments`.`id`'
-      printf ' OR NOT '
-      mysql_query_has_pending_dependencies '`build_command_architectures`.`id`' '`build_assignments`.`id`'
+      printf ' OR `packages_with_pending_dependencies`.`build_assignment` IS NULL'
       printf ' OR `toolchain_order`.`pkgbase` IS NOT NULL'
     printf ')'
     printf ' AND `binary_packages_in_repositories`.`repository`=%s' \