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

    Details

    • 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

            Structure

              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:

                    Structure Helper Panel