-
Bug
-
Resolution: Fixed
-
Low
-
7.2.11, 7.6.4, 7.13.0, 7.6.10
-
7.02
-
10
-
Severity 2 - Major
-
37
-
-
Problem Definition
Currently findRapidViewsByProject scans all RapidViews to find Boards which are related to a specific project.
As a part of that logic, it does permission checks for each project found as part of JQL scan. Later some of the projects removed and permission check is done again.
Steps to reproduce
- Create 1k projects, 2k boards
- Make your current user lead for all of those projects.
- Change search query to project in projectsLeadByUser() ORDER BY Rank asc
(Not real life case, but it makes problem obvious) - Open any board
Actual result: updateLastVisitedProject takes 17sec
Expected result: updateLastVisitedProject finishes is reasonable time...
Suggested Solution
Skip permission check at the JQL scan stage and do permission check only after filtering.
Notes
See JSWSERVER-16130 for more context
- causes
-
JSWSERVER-16130 Performance of findRapidViewsByProject degrades with number of Boards
- Closed