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

Increase the default value of defaultRowPrefetch for Oracle

XMLWordPrintable

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

      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

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

              Created:
              Updated: