[
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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
