Uploaded image for project: 'Qpid'
  1. Qpid
  2. QPID-7974

JdbcUtils.TableExists is very slow on big databases such as Oracle

Agile BoardAttach filesAttach ScreenshotVotersStop watchingWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      Description

      The problem is that JdbcUtils.tableExists will actually load all tables and then iterate to find the correct one. On Oracle, this can be around 40 000 tables. So it will take 12 minutes for the broker to start.

        Attachments

          Activity

            People

            • Assignee:
              rgodfrey Robert Godfrey
              Reporter:
              adelboutros@live.com Adel Boutros

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment