JIRA XML API takes a long time to return XML data (JQL search result).
There are some integrations (Confluence gadgets ie) that utilize Jira XML API to search and retrieve issues from a filter:
The same JQL query based on a defined filter:
- takes around 30 seconds to gather data via XML API
- takes less than a few seconds via Jira UI.
Observable slowness is not related to enabled add-ons in Jira. Issue is not related to JQL complexity, however it's connected to custom fields usage in the query.
The slowness is related to XML API only, not the JQL itself.
Jira > 7.0 versions.
Execute a JQL query that contains any custom field via Jira XML API (searchRequest method):
Execution time is equal (or is close) to the execution time of JQL through web UI.
Execution time is significantly worse than the same JQL through web UI.
Any integration with Jira XML API is affected (including Atlassian products)
No workaround found.