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

Investigate if table scans on the configuration context could cause performance issues

    XMLWordPrintable

Details

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      At the moment some of the queries JIRA runs on the configurationcontext database table perform table scans. This does cause problems as the number of records in this table is small. The numebr of records does depend on the number of custom fields that are set up and how these are configured (i.e. it depends on the number of contexts, project/issue type configurations, each custom field has).

      We should investigate if the table scans could become a problem in the future, and if we can/should put more indexes in place on the configurationcontext table.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              anton@atlassian.com AntonA
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: