[ https://issues.apache.org/jira/browse/QPID-7974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16209261#comment-16209261 ]
ASF GitHub Bot commented on QPID-7974: -------------------------------------- GitHub user adel-boutros opened a pull request: https://github.com/apache/qpid-broker-j/pull/3 QPID-7974: Only search for the needed table instead of querying the w… QPID-7974: Only search for the needed table instead of querying the whole database tables You can merge this pull request into a Git repository by running: $ git pull https://github.com/adel-boutros/qpid-broker-j fix_jdbc_table_exist Alternatively you can review and apply these changes as the patch at: https://github.com/apache/qpid-broker-j/pull/3.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #3 ---- commit 78c5d25c2ed79751e7456467178213a0585f1f5a Author: aboutros <about...@murex.com> Date: 2017-10-18T12:41:42Z QPID-7974: Only search for the needed table instead of querying the whole database tables ---- > JdbcUtils.TableExists is very slow on big databases such as Oracle > ------------------------------------------------------------------ > > Key: QPID-7974 > URL: https://issues.apache.org/jira/browse/QPID-7974 > Project: Qpid > Issue Type: Improvement > Components: Java Broker > Affects Versions: qpid-java-6.1.4 > Reporter: Adel Boutros > > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@qpid.apache.org For additional commands, e-mail: dev-h...@qpid.apache.org