[Spacewalk-devel] Re: 475324 - Ported SSM upgrade to Java and added support for multiarch.
jason.dobies at redhat.com
Tue Dec 9 08:36:09 EST 2008
> 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 :).
Ahhhh... I was missing the parentheses around the three values when I
first tried that. Thanks for the heads up. :)
Jason Dobies (jason.dobies at redhat.com)
Senior Software Engineer
RHN Satellite & Spacewalk
Freenode: jdob @ #spacewalk, #spacewalk-devel
More information about the Spacewalk-devel