> 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 ([EMAIL PROTECTED])
Senior Software Engineer
RHN Satellite & Spacewalk
Freenode: jdob @ #spacewalk, #spacewalk-devel

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to