java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 2408dba53bce2d140caa4a99d9cb1574b98128ad
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Tue Dec 22 10:56:39 2009 -0500
526823 - improving speed of scheduling package installs for 1000s of systems
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml
index 74d293d..3b2f422 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml
@@ -601,8 +601,8 @@ SELECT DISTINCT SP.server_id id,
SP.name_id || '|' || SP.evr_id || '|' || SP.package_arch_id AS
ID_COMBO
FROM rhnServerPackage SP
WHERE SP.server_id IN (%s)
- AND SP.name_id || '|' || SP.evr_id || '|' || SP.package_arch_id IN
(SELECT element || '|' || element_two || '|' || element_three FROM rhnSet
WHERE user_id = :user_id AND label = :package_set_label)
- </elaborator>
+ AND exists (select 1 from rhnSet where user_id = :user_id and label =
:package_set_label and element = SP.name_id and element_two = SP.evr_id and element_three
= SP.package_arch_id)
+ </elaborator>
</mode>
<mode name="system_set_remove_or_verify_packages_conf">
Show replies by thread