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

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 Labels: jdg, jdg6 Fix For: 6.0.0.Final 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.