qpid-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (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:43:00 GMT

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


Mime
View raw message