Update Profile to avoid LocalSite queries if LocalSites aren't used.

Review Request #12354 — Created June 11, 2022 and submitted — Latest diff uploaded

Information

Review Board
release-5.0.x

Reviewers

This updates Profile.get_starred_review_groups_count(),
Profile.get_starred_review_requests_count(), and related functions to
avoid factoring in a LocalSite value if Local Sites aren't used in the
deployment.

Most deployments do not use Local Site functionality. By performing this
check, we're able to avoid a JOIN between LocalSite and a starred
object, instead letting us operate on the through tables, just like
when LocalSite.ALL is passed. The vast majority of deployments will
benefit from this improved performance, especially combined with the new
caching.

All unit tests pass.

Commits

Files