Indexing processing very slow after upgrading to Agile 6.4 and above on Oracle database

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Medium
    • None
    • Affects Version/s: 6.4.4, 6.4.5
    • Component/s: None
    • 6.04

      Symptom:

      JIRA re-indexing (foreground and background) taking too much time after upgrading to Agile 6.4 and above (lexo rank)

      Diagnosis:

      JIRA runs on Oracle database

      Cause:

      When running against Oracle, queries with limit set are executing and returning all rows. Those that are outside the limit are ignored. This causes severe database performance problems as it has to process all rows. This is related to AO-549

            Assignee:
            Unassigned
            Reporter:
            vkharisma
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: