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
