Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-38825

Improve Database Indexes to the PROPERTYENTRY Table

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

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

      I am creating this issue as per the feedback from one of our customers.
      He reported that after his DBA reviewed their AWR reports, they noticed that a query to the PROPERTYENTRY table (copied below) was among the top queries by elapsed time and CPU time, gets and executions.

      SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM propertyentry WHERE ENTITY_NAME=:1 AND ENTITY_ID=:2 AND PROPERTY_KEY=:3

      After modifying an existing index for this table , they saw an improvement of 35 times in the access speed and CPU usage.
      This might be Oracle-specific, but I think we should review whether this index should not be modified during the JIRA installation.

      Attachments

        Issue Links

          is related to

          Suggestion - JRASERVER-38825 Improve Database Indexes to the PROPERTYENTRY Table

          • Closed

          Suggestion - JSWCLOUD-6925 Investigate SQL query count executed for a single request

          • Gathering Interest

          Activity

            People

              Unassigned Unassigned
              dconrad Danilo Conrad
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: