Slow performance of a query used to take 4x less time than now

[Ahmed Fathy]

I have this JQL 

project in (CRM) AND issuetype in ("Request For Assistance", Defect, "Customer Defect") AND (Backlog is EMPTY OR Backlog != No) AND status changed to ("Release Pending", Released, Closed) during ("2017-10-09 00:00", "2017-10-15 23:59") and status was in ("Release Pending", Released, Closed) on "2017-10-15 23:59"

It was taking 1-2 seconds few months ago, now it takes 8, we have automation around this query, so having it taking 8 seconds is killing performance and make automation take up to 8 hours to be completed. 

[Marko Filipan]

Hi Ahmed,

I suppose that your system contains more issues and data than few months ago. Therefore, database queries take more time to return results.

In order to maintain performance, you should consider scaling your system according to the JIRA Sizing Guide (if you already didn't do so), that you can find here:
https://confluence.atlassian.com/enterprise/jira-sizing-guide-461504623.html

You can also find JIRA performance tuning guide:
https://confluence.atlassian.com/jirakb/jira-applications-performance-tuning-229179856.html

and database related knowledge base:
https://confluence.atlassian.com/confkb/database-troubleshooting-180847246.html

Cheers,

Marko