]
RH Bugzilla Integration commented on ISPN-2454:
-----------------------------------------------
Jitka Kozana <jkudrnac(a)redhat.com> changed the Status of [bug
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.