[infinispan-issues] [JBoss JIRA] (ISPN-2454) The current SQL query that checks table existence is under optimized on big database

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-2454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12982336#comment-12982336 ] 

RH Bugzilla Integration commented on ISPN-2454:
-----------------------------------------------

Jitka Kozana <jkudrnac at redhat.com> changed the Status of [bug 1087236|https://bugzilla.redhat.com/show_bug.cgi?id=1087236] from NEW to CLOSED

> The current SQL query that checks table existence is under optimized on big database
> ------------------------------------------------------------------------------------
>
>                 Key: ISPN-2454
>                 URL: https://issues.jboss.org/browse/ISPN-2454
>             Project: Infinispan
>          Issue Type: Enhancement
>      Security Level: Public(Everyone can see) 
>          Components: Loaders and Stores
>    Affects Versions: 5.1.0.FINAL
>            Reporter: Nicolas Filotto
>            Assignee: Tristan Tarrant
>              Labels: jdg, jdg6
>             Fix For: 5.2.0.Beta4
>
>
> Last year I proposed an enhancement allowing to use the implicit db schema to ease life of end-user, unfortunately it seems that it affects the startup time of the product when the tables contain a lot of rows. Indeed the query can take several seconds to return a result.
> The idea of this task would be to optimize this query for all supported databases in order to avoid this drawback.



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)