JIRA - (3.13.5) - export to Excel very slow

Question

Hi,

Our organisation is using JIRA 3.13.5 Enterprise and will be upgrading to a new version sometime this year.

However, we have an issue where the users are exporting search results to Excel spreadsheet and it takes a considerable amount of time.

For example:
10 minutes to export an Excel file that is 4 MB (about 600 records) in size. The transfer rate is about 6.41KB/sec.

Is there a way to find out what the database query that performs the export to Excel process?
Or what is the database query that is involved with the export to Excel process?

I'm not entirely sure if this is part of a plug-in or something else entirely.

It's possible that the query is having the issue.

Thank you

unknown · Answer

Here's is the findings that may help other people who are in similar situation - though, it isn't entirely clear - it might provide some clues to the issue. And the idea is based on what Nic has suggested in terms of the custom field.

---------------------------------------------------------

I noticed that when I do an export of CURRENT fields into Excel, it is a lot faster - compared to ALL fields.

I compared the two Excel spreadsheet and the one with current fields has a lot less columns compared to the all fields spreadsheet.

Is it possible that with ALL fields; there are more complex queries formed, thus slowing down the extract and export?

There is a section in the Administration option that allows for the customisation/addition of fields; but I'm not sure how that works for the spreadsheet or on the search result screen.

Is it possible that somewhere between last year and February this year; someone might have added new fields that could result in this performance issue we're seeing now?

---------------------------------------------------------

I was advised by the user that they'll use a workaround and await for a system upgrade instead.

unknown · Answer

Thank you for your response and suggestions; and apologies for my very late response. We did try to look into that eventually. But, we weren't able to get anything conclusive. Though, hopefully, we'll be moving on to a newer version without these issues. Thank you again.

Nic Brough -Adaptavist- · Answer

It's not necessarily the database - the export view is based on the issue navigator, which uses the index primarily.

Building the excel output seems to be quite cpu and memory intensive from what I've seen, so I'd be looking at that (and the speed of the disk the index is on maybe) first.  Even on fast Jira installations, the export takes a while, although 600 records should still be under a minute, not ten!  I'd also be looking at what's in the download - I've seen an export slowed to a crawl by a custom field once, although that was a while ago and down to a 3rd party plugin - check if there are any non-standard fields in the output.