Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-67095

JIRA XML API takes a long time to return XML data (search request)

    XMLWordPrintable

Details

    Description

      Summary

      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.

      Environment

      Jira > 7.0 versions.

      Steps to Reproduce

      Execute a JQL query that contains any custom field via Jira XML API (searchRequest method):

      Expected Results

      Execution time is equal (or is close) to the execution time of JQL through web UI.

      Actual Results

      Execution time is significantly worse than the same JQL through web UI.

      Notes

      Any integration with Jira XML API is affected (including Atlassian products)

      Workaround

      No workaround found.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tdudzisz Tomasz Dudzisz (Inactive)
              Votes:
              26 Vote for this issue
              Watchers:
              30 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: