-
Suggestion
-
Resolution: Low Engagement
-
None
-
2
-
NOTE: This suggestion is for JIRA Software Cloud. Using JIRA Software Server? See the corresponding suggestion.
JAG uses JIRA's property sets to store configurations. We frequently access these property sets in various services (ex. SprintCustomFieldServiceImpl).
However we don't cache these property sets, thus resulting in a lot of unnecessary db access to retrieve the data for the sets each time we want to read a property.
We should apply an appropriate caching strategy for these property sets.
This has appeared to cause significant bottlenecking in a customer instance, where almost every JIRA Agile thread is blocked on a thread waiting on a response from the database due. Screenshot of threads attached.
- is related to
-
JSWCLOUD-6925 Investigate SQL query count executed for a single request
- Gathering Interest
-
JSWSERVER-10819 Cache frequently used PropertySets
- Gathering Interest