Subqueries take long to reindex

Problem

Subqueries take a long time to reindex and the search results are out of date

Solution

Subqueries are a legacy functionality and they suffer from performance problems. The issue is more prominent if there are many subqueries in place.

A quick fix could be to delete unused subqueries but the recommended approach is to use the new Extended Search screen for your use cases. This way you can save your queries as Jira filters and achieve much better reindexing times.

Make sure to read about migrating from Subqueries to Extended search: Use Extended Search functions instead of Subqueries

Related articles