Bug 781057 (SOA-3543) - VDB deployment in EDS can be extremely slow based upon indexing needs
Summary: VDB deployment in EDS can be extremely slow based upon indexing needs
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3543
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.3.0 GA
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks: 781058
TreeView+ depends on / blocked
 
Reported: 2011-11-01 16:33 UTC by jolee
Modified: 2011-12-07 14:40 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
JBoss Enterprise Data Services Platform 5.1.0
Last Closed: 2011-11-11 04:45:53 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 781058 1 None None None 2021-01-20 06:05:38 UTC
Red Hat Issue Tracker SOA-3543 0 Major Closed VDB deployment in EDS can be extremely slow based upon indexing needs 2014-05-20 15:00:21 UTC

Internal Links: 781058

Description jolee 2011-11-01 16:33:08 UTC 
Help Desk Ticket Reference: https://na7.salesforce.com/500A0000008SHwx
Steps to Reproduce: Deploying a VDB w/a large amount of schemas will expose this problem.  It is extremely apparent when deploying to Solaris systems in particular.
project_key: SOA

Problem:
The index metadata loading logic is not well optimized. In short, each time a call to IndexMetadataFactory.queryIndex is made the blocks are fully scanned.  For small VDBs there isn't much of an issue because of the block caching logic, but during a vdb deploy we could be constantly re-reading data from the files.

Possible solution:
The IndexMetadataFactory loading strategy should be made aware of the index file per schema strategy so that scans can be made per schema rather than against all index files.
Comment 1 jolee 2011-11-01 16:33:08 UTC 
Link: Added: This issue Cloned from TEIID-1803
Comment 2 jolee 2011-11-01 16:36:02 UTC 
Security: Added: Public
Comment 3 jolee 2011-11-01 19:19:33 UTC 
Link: Added: This issue Cloned to SOA-3544
Comment 4 Van Halbert 2011-11-11 04:45:53 UTC 
Date: 2011-11-03 10:09:11 -0400 (Thu, 03 Nov 2011)
New Revision: 3604

Modified:
  trunk/metadata/src/main/java/org/teiid/metadata/index/IndexMetadataFactory.java
  trunk/metadata/src/main/java/org/teiid/metadata/index/RecordFactory.java
Comment 5 jolee 2011-12-07 14:39:41 UTC 
Link: Added: This issue is a dependency of SOA-3544
Comment 6 jolee 2011-12-07 14:40:33 UTC 
Link: Added: This issue depends TEIID-1803
Note You need to log in before you can comment on or make changes to this bug.