Skip to content

Improve epic swimlanes loading performance for group issue board

Felipe Artur requested to merge issue_243606-improve_epic_swimlanes_query into master

What does this MR do and why?

Improves loading of epics swimlanes on group issue boards. Removing aORDER BY DESC
from an authorization subquery gives a performance increase.

Before removing order statement

For some reason Postgres loads 3 million rows when having order statement on subquery: producing heavy load on

This disappears when removing the following line from query: $2212568#LC414

After removing order statement

related to #243606 (closed)

Edited by Felipe Artur

Merge request reports