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

fix: Optimize SQL query when filtering PRs with labels

Download Browse

The existing query works but is heavy as it requires to compare all the PRs of the instances against a set of labels. The changes made in this contribution allows the DB engine to use the indexes of the PRs and labels tables. No functional changes expected. Part of story #35825 Pull request new home page - Filter on labels Change-Id: I5a98e58d48fcf8eccc90af09e8eaf5470411ba67

+92 −42
Thomas Gerbet (tgerbet) 2024-02-09 18:13
Thomas Gerbet (tgerbet) 2024-02-09 18:31
e0a9a9777d68c334cca4c5c5073481d6131ce6ab
466e8507457865d6fa6c8a5ac4bc5d6aa3a4fced
git #tuleap/stable/e0a9a9777d68c334cca4c5c5073481d6131ce6ab

Modified Files

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