[
https://issues.apache.org/jira/browse/QPID-7974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16209304#comment-16209304
]
ASF subversion and git services commented on QPID-7974:
-------------------------------------------------------
Commit 3a6bb20dc037a88d528045eae4bcc2daacf955ae in qpid-broker-j's branch
refs/heads/master from aboutros
[ https://git-wip-us.apache.org/repos/asf?p=qpid-broker-j.git;h=3a6bb20 ]
QPID-7974: Only search for the needed table instead of querying the whole
database tables
This closes #3
> 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]
