On 26/02/2013, at 4:31 PM, Chris Behrens <[email protected]> wrote:
> After thinking more, it does seem like we're doing something wrong if the > query itself is returning 300k rows. :) I can take a better look at it in > front of the computer later if no one beats me to it. Yeah I think it's more than a missing index :-) The query does 2 INNER JOINS on aggregate_hosts then 2 INNER JOINS on aggregate_metadata then does a further 2 LEFT OUTER JOINS on aggregate_hosts. Thanks for the help, Sam _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : [email protected] Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
