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

Ahmed Fathy October 13, 2017

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. 

1 answer

1 vote
Marko Filipan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 23, 2017

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

Suggest an answer

Log in or Sign up to answer