Uploaded image for project: 'Project Configurator - Development'
  1. Project Configurator - Development
  2. PCDEV-709

Improve performance of filtering custom fields by values used in exported projects on large databases

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 2.3.3-J7
    • Fix Version/s: 2.3.4-J7
    • Critical Points:
      0

      Description

      A customer with a Data Center instance and a very large database running on Oracle, suffers very long export times when filtering custom fields by values used in the exported projects. Finally it was confirmed that the problem was caused by the DB query that performs that filtering based on custom field values. Further tests confirmed that an alternative form of the query provided much better performance.

      The fix version includes the improved queries, also for the "Used by" report.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              pmaranon Pepe Maranon Mora
              Reporter:
              pmaranon Pepe Maranon Mora
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: