Optimize querying with private review requests.

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

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.

david
  1. Ship It!

  2. 
      
chipx86
Review request changed
Status:
Completed
Change Summary:
Pushed to release-1.7.x (9ff66aa)
chipx86
Review request changed
Status:
Completed
Change Summary:
Pushed to master (9ff66aa)
chipx86
Review request changed
Status:
Completed
Change Summary:
Pushed to release-2.0.x (9ff66aa)