Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2050

Avoid checking for child views unless operating on table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.3.1
    • Fix Version/s: 4.5.0
    • Labels:
    • Flags:
      Patch

      Description

      Whenever a view is dropped, MetaDataEndPointImpl.findChildViews() checks whether it has child views or not. This is doing a full scan in all the rows in SYSTEM.CATALOG which reduces performance. When the number of rows is very high, it causes timeout. The check has to be done only for the tables.

        Attachments

          Activity

            People

            • Assignee:
              jamestaylor James Taylor
              Reporter:
              arun1087 Arun Kumaran Sabtharishi
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: