Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

stable

Clone or download

Read-only

perf: Avoid a full scan of the DB table when filtering PR "related to me"

Download Browse

Moving the filtering of this filter inside the query allows the DB to apply all the "easy" filters before considering to look into the list of changes. It is easier for the DB to come with an optimized plan for this. No functional changes. Part of story #35823: Pull request new home page - Filter on Related to me Change-Id: Ib07997311924c782031a0d923bc07cdefd84bb52

+99 −21
Thomas Gerbet (tgerbet) 2024-03-20 09:33
Thomas Gerbet (tgerbet) 2024-03-20 09:39
5cf8e0de9545dec6bac872e2e29421264888f19a
40b2f5e7a23fd790a9ed6efd05246dee4775d7b8
git #tuleap/stable/5cf8e0de9545dec6bac872e2e29421264888f19a

Modified Files

Side by side diff
Inline diff
Name
M plugins/pullrequest/include/PullRequest/Dao.php +38 −19 Go to diff View file
M plugins/pullrequest/include/PullRequest/PullRequestDAOSearchCriteria.php +2 −2 Go to diff View file
A plugins/pullrequest/include/PullRequest/PullRequestDAOTableJoin.php +59 −0 Go to diff View file