Comment 4 for bug 711077

A considerable portion of that 5-second gap is actually taken up by the getBugBranchesForBranches query itself. Furthermore, dereferencing bug_branch.branch may be taking too much time even when the branch object is already in the ORM cache.

Instead, we could specialize this query to return only the (distinct) branch ids. That is all that the view is really trying to find out.