Increase the default value of defaultRowPrefetch for Oracle

XMLWordPrintable

    • 2
    • 8

      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

            Assignee:
            Unassigned
            Reporter:
            Andriy Yakovlev [Atlassian]
            Votes:
            5 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: