Slow execution of Project - Fields are caused by large number configuration items (custom-fields) present in the view. JIRA inefficiently computes number of related screens and doesn't cache some custom-fields data to optimize the performance.
Large JIRA instance
- with many custom-fields (1000+)
- with many fieldlayouts items:
- with many screens
- Create large JIRA instance
- Open Project configuration screen
- Go to Fields Scheme (<JIRA>/plugins/servlet/project-config/<PRG>/fields)
Initial load time is low (< 30 seconds) time and second execution is fast (< 10 seconds).
Call takes 80-90 seconds, second call still slow.
From SQL log you can see a lot of calls to DB. Total number of executed SQLs 11850:
Second call still does a lot of SQL call to managedconfigurationitem table, this data is not cashed:
This is performance problem in JIRA. You can lower the impact by reducing the number of items (custom-fields) for Field Configuration for project, to do that, please Hide the field.