Summary

Advanced Roadmaps (formerly Portfolio for Jira) long running thread on getRelevantCustomFieldIds() due to inefficient query causing Performance.

Details

Custom fields are loaded when a plan is being loaded. The query will retrieve a list of plan IDs (from AO_D9132D_PLAN) and then for each plan ID another query runs against AO_D9132D_PLAN_CUSTOM_FIELD to retrieve a list of the custom fields linked to that plan. When there are a large number of existing plans, it is slow to load custom fields for all plans. 

Workaround

Not available at the moment