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] [Updated] (QPID-7974) JdbcUtils.TableExists is very slow on big databases such as Oracle
Date Wed, 18 Oct 2017 13:15:01 GMT

     [ https://issues.apache.org/jira/browse/QPID-7974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rob Godfrey updated QPID-7974:
------------------------------
    Status: Reviewable  (was: In Progress)

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


Mime
View raw message