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

Avoid checking for child views unless operating on table

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.3.1
    • 4.5.0
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jamestaylor James R. Taylor
            arun1087 Arun Kumaran Sabtharishi
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment