Skip to content

Improve performance of finding issues with/without labels

yorickpeterse-staging requested to merge finding-issues-by-labels-performance into master

The changes in this MR ultimately lead to finding issues with(out) labels being about 2x faster due to:

  1. Newly added indexes on issues.state and projects.visibility_level
  2. Adjusting the query so that finding issues for multiple projects is more efficient

Merge request reports