qpid-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rob Godfrey (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (QPID-7974) JdbcUtils.TableExists is very slow on big databases such as Oracle
Date Wed, 18 Oct 2017 12:30:01 GMT

    [ https://issues.apache.org/jira/browse/QPID-7974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16209246#comment-16209246
] 

Rob Godfrey commented on QPID-7974:
-----------------------------------

[~adelboutros@live.com] That would be good - thx.  Also, in terms of PRs, it's generally better
to raise a separate PR for each JIRA and to have the JIRA id in the PR comment as this should
then automagically link the PR and the JIRA I think.

> 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-unsubscribe@qpid.apache.org
For additional commands, e-mail: dev-help@qpid.apache.org


Mime
View raw message