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

Increase the default value of defaultRowPrefetch for Oracle

    XMLWordPrintable

Details

    • 2
    • 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

      Problem Definition

      The default Oracle JDBC driver fetch size (10) might cause more roundtrips to DB and this leads to a longer time to fetch results from queries executed on an Oracle DB, which results in slowness for users when loading pages and performing actions in Jira.

      Suggested Solution

      Ship Jira with larger defaultRowPrefetch size. This can improve specific operations x4-x6 times.

      Workaround

      Apply the changes manually from KB Using the default Oracle JDBC fetch size may lead to performance issues in Jira

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. JSWSERVER-20618 Performance of Jira can degrade significantly due to slow sprint cache population

          • High - High priority issues
          • Closed
          mentioned in

          Page Loading...

          Page Loading...

          Activity

            People

              Unassigned Unassigned
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Votes:
              5 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: