We have over 6,000 users using our JIRA instance where a handful of them are creating many filter queries. Is there a standard document your team can suggest in writing queries I can share with my users? Some of their queries take an extremely long time to return results.

5 answers

You will find the usage guide here but that is more of syntax and not best practices. The general rule is to keep the result set small and that will improve the performance.

For example, if you have 100K issues returning from the "parent" function, it will take more time than when it returns 1000 issues. In the above query, looks like you are expecting to see only issues from MFOL project and so you can include that criteria inside the parent function. Updated query will look like:

Thank you for the information. We want to upgrade our instance from JIRA 6.2.5 but need to know which version of JIRA we should upgrade to. Is JIRA-36368 issue resolved in the version of JIRA 6.3.14 which is the latest?

I have seen better numbers but that is when the queries were taking over a minute. Having said that, the biggest improvement will only come when JRA-39375 is implemented. I am waiting for that fix too.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

This is an example where you do not have any plugin functions. It is not the number of issues returned in the end. The key is to reduce the number of issues returned for each clause. What are you trying to do in this query?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Get ready! Demo Den Episode 4 is coming your way on Tuesday, May 28, 2018 with a Continuous Integration and Delivery special demo. CircleCI Director of Solutions Engineering, Eddie Webb will show us ...