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

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

      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.

            [JRASERVER-67095] JIRA XML API takes a long time to return XML data (search request)

            Andriy Yakovlev [Atlassian] made changes -
            Link New: This issue is caused by CONFSERVER-56017 [ CONFSERVER-56017 ]
            Przemyslaw Czuj (Inactive) made changes -
            Resolution New: Answered [ 9 ]
            Status Original: Gathering Impact [ 12072 ] New: Closed [ 6 ]
            Rob made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 517055 ]
            SET Analytics Bot made changes -
            UIS Original: 8 New: 18
            SET Analytics Bot made changes -
            UIS Original: 7 New: 8
            Bugfix Automation Bot made changes -
            Support reference count Original: 12 New: 24
            Bugfix Automation Bot made changes -
            Support reference count Original: 24 New: 12
            SET Analytics Bot made changes -
            UIS Original: 14 New: 7
            SET Analytics Bot made changes -
            UIS Original: 15 New: 14
            SET Analytics Bot made changes -
            UIS Original: 29 New: 15

              Unassigned Unassigned
              tdudzisz Tomasz Dudzisz (Inactive)
              Affected customers:
              26 This affects my team
              Watchers:
              30 Start watching this issue

                Created:
                Updated:
                Resolved: