Optimize querying with private review requests.

Review Request #5669 — Created April 2, 2014 and submitted — Latest diff uploaded

Information

Review Board
release-1.7.x
0ebf9b5...

Reviewers

When querying lists of review requests that contained private review
requests, the query ended up joining enough tables where the query could
take a substantial amount of time to execute.

This change optimizes the query by pulling out a couple of the more
expensive joins into a couple simple queries. The result is a much
faster query.

All unit tests passed.

Ran some sample queries on reviews.reviewboard.org, and saw the speed
differences.

    Loading...