[
https://issues.apache.org/jira/browse/QPID-7974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16209395#comment-16209395
]
Lorenz Quack commented on QPID-7974:
------------------------------------
I just had a very brief look but the commit seems wrong.
It looks like if the tableName is all lower or all upper case tableExists will
always return true regardless of whether the table exists or not.
> 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
> Assignee: Rob Godfrey
> Fix For: qpid-java-broker-7.0.0
>
>
> 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]
