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

    • New Feature
    • Status: Done
    • High
    • Resolution: Fixed
    • 2.3.3-J7
    • 2.3.4-J7
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: