You'll also greatly benefit from ordering the getPendingUpdates joins the way we want the query to be executed: SPPH, SPR, then Archive.
And it might be worth looking at batching the updates (using a CASE expression is the best way, sadly), but that's a far less critical optimisation. -- https://code.launchpad.net/~wallyworld/launchpad/another-reporting-cache-garbojob-1071581/+merge/133859 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
