Bug 1087236

Summary: Infinispan issue: The current SQL query that checks table existence is under optimized on big database
Product: [JBoss] JBoss Enterprise Application Platform 6 Reporter: Boleslaw Dawidowicz <bdawidow>
Component: ClusteringAssignee: Paul Ferraro <paul.ferraro>
Status: CLOSED NOTABUG QA Contact: Jitka Kozana <jkudrnac>
Severity: unspecified Docs Contact: Russell Dickenson <rdickens>
Priority: unspecified    
Version: 6.3.0CC: jkudrnac, kkhan, mmarkus
Target Milestone: ---   
Target Release: EAP 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-07-04 11:17:03 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1087264    
Bug Blocks:    

Description Boleslaw Dawidowicz 2014-04-14 07:23:20 UTC 
"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."

"It seems that the Query for MS SQL doesn't work on MS SQL 2008 R2, it should be
SELECT count(*) from (SELECT TOP (1) 1 as C FROM " + tableName + ") T
"
Comment 1 Boleslaw Dawidowicz 2014-04-14 07:24:02 UTC 
Needed for JBoss Portal 6.2
Comment 2 Mircea Markus 2014-04-23 15:48:14 UTC 
This has been fixed since Infinispan 5.2.0 and is contained in Infinispan 5.2.9 (nothing to do here)
Comment 3 Jitka Kozana 2014-07-04 11:17:03 UTC 
Closing based on comment #2.