Long time of response transitioning from issues view to agile board

Hi dear JIRA users,

A few weeks ago we notice that when pressing "More" -> "Agile Board" button from an issue, it takes a lot of time to show that issue on the board. We thought that it may be a problem within the amount of issues submitted on the project, or the issues displayed on the agile board, but then we check it with a project that have only 5 issues, and the time of response is still very slow (from 1 to 2 minutes). We ask about this to our infrastructure area, but it says that the requirements are fine.

What do you think about this problem? 

Thanks in advance!!

1 answer

1 accepted

Accepted Answer
0 votes
Chris Fuller Atlassian Team Feb 25, 2015

See https://jira.atlassian.com/browse/GHS-8775

JIRA Agile does not "just know" which board(s) an issue is on; it must try out the JQL from every board in the system to see if your issue turns up in the results or not.  This is fixed if you are running JIRA Agile 6.6.0 with JIRA 6.4 (not yet released, but it should be available soon).

The fix involves building a temporary index that contains only that issue so that multiple JQL queries can be run against it very quickly, but this requires support from JIRA itself, hence the need to be on JIRA 6.4 to take advantage of it.

In the meantime, the best advice I can give is to watch the atlassian-jira-slow-queries.log file as you attempt this.  Very likely, one or more of the agile boards on the system has very expensive JQL and will show up there.  You can then track this back to those agile boards and try to optimize the queries that they are using.

This is a whole topic in itself, but one quick tip I can give you is to try to avoid using expressions like filter IN (...) to join multiple queries together.  You might be tempted to do this when you have several sub-projects and want to also have a board that composes all of them, but this is implemented by nesting those queries, so it can be very expensive.  If you can express that sort of thing more simply, such as just with project IN (...), you will get much better performance in general.  There are also certain JQL functions, particularly those provided by third party developers or that are not maintained, that never really get tested on large instances, so that's another thing you can keep an eye out for.

 

Thanks Chris for you quickly answer. Our release version is 6.1.3 on JIRA and JIRA Agile 6.4.2. We think that the upgrade of our tools will be applied soon, so we are going to check what you say about filters and calculate the time of response again.

Thanks a lot! 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

449 views 7 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you