> 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