Fedora Hosted Git Repositories - spacewalk.git/rss log, Jason Dobies <> wrote: % 475324 - Ported SSM upgrade to Java and added support for multiarch. % % • [DH] java/code/src/com/redhat/rhn/common/db/datasource/xml/ % System_queries.xml ... % URL: http://git.fedoraproject.org/git/?p=spacewalk.git;a=commitdiff;h= % cdd16819a0f5066474225ac7316973cf72d0bfb4
... - AND P.id IN ( - SELECT element - FROM rhnSet - WHERE user_id = :user_id - AND label = 'package_upgradable_list' -) + AND P.name_id IN ( + SELECT element + FROM rhnSet + WHERE user_id = :user_id + AND label = :package_set_label + ) + AND P.evr_id IN ( + SELECT element_two + FROM rhnSet + WHERE user_id = :user_id + AND label = :package_set_label + ) + AND P.package_arch_id IN ( + SELECT element_three + FROM rhnSet + WHERE user_id = :user_id + AND label = :package_set_label + ) ... Hi Jason, please modify queries to use AND (P.name_id, P.evr_id, P.package_arch_id) IN ( SELECT element, element_two, element_three FROM rhnSet ... ) i.e. single IN condition for all three values. Simply - it's much faster :). -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel