[Spacewalk-devel] Re: 475324 - Ported SSM upgrade to Java and added support for multiarch.

Jason Dobies 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 mailing list