It seems to make no appreciable difference when hot (the index scan on bugtaskflat__bug__idx or bugtask__bug__idx takes a millisecond either way), so all other things being more or less equal I think it makes sense to involve fewer tables in the query. -- https://code.launchpad.net/~cjwatson/launchpad/optimise-commented-bugs-search-more/+merge/371750 Your team Launchpad code reviewers is subscribed to branch lp:launchpad.
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
