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

[Nicolas Filotto (JIRA)]

Nicolas Filotto created ISPN-2454:
-------------------------------------

             Summary: 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
          Components: Loaders and Stores
    Affects Versions: 5.1.0.FINAL
            Reporter: Nicolas Filotto
            Assignee: Mircea Markus


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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira