Bug 781071 (SOA-3559)

Summary: EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Pavel Macik <pmacik>
Component: Performance, EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.2.0.ER4, 5.2.0.ER5, 5.2.0.ER6CC: vhalbert
Target Milestone: ---   
Target Release: 5.3.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3559
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-12-12 16:08:12 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:

Description Pavel Macik 2011-11-07 09:29:54 UTC 
Workaround Description: https://issues.jboss.org/browse/SOA-3559

There is a performance degradation in select queries from XML datasource. The workaround is to use an xquery expression that disables streaming (in other words, instead of '/a/b/c', use something like '/*[local-name()='a']/b/c'.)  Only do this if the parsed footprint of the document is relatively small.
project_key: SOA

The eds_xmlfile_select scenario shows ~30% performance degradation in select queries from XML datasource.

See the "(EDS) Files select - Charts" sheet of the document at [1] for details.

[1] https://docspace.corp.redhat.com/docs/DOC-56368
Comment 1 Van Halbert 2011-11-07 13:21:39 UTC 
Can we get the VDB and file used for in the test?  Thx.
Comment 2 Van Halbert 2011-11-07 13:44:59 UTC 
Link: Added: This issue Cloned to SOA-3561
Comment 3 Van Halbert 2011-11-09 15:59:28 UTC 
Release Notes Docs Status: Added: Documented as Known Issue
Release Notes Text: Added: Use an xquery expression that disables streaming: e.g. instead of '/a/b/c' something like '/*[local-name()='a']/b/c'.  That should only be done of course if the parsed foot print of the document is relatively small.
Workaround Description: Added:  The workaround is to use an xquery expression that disables streaming: e.g. instead of '/a/b/c' something like '/*[local-name()='a']/b/c'.  That should only be done of course if the parsed foot print of the document is relatively small.
Comment 5 Van Halbert 2011-11-14 12:37:50 UTC 
Link: Added: This issue is related to TEIID-1824
Comment 6 Steven Hawkins 2011-11-14 15:15:32 UTC 
Link: Removed: This issue is related to TEIID-1824
Comment 7 Van Halbert 2011-11-14 20:13:17 UTC 
Link: Added: This issue is related to TEIID-1824
Comment 8 Van Halbert 2011-11-14 20:25:46 UTC 
Link: Removed: This issue is related to TEIID-1824
Comment 9 David Le Sage 2011-11-15 00:45:27 UTC 
Writer: Added: dlesage
Workaround Description: Removed:  The workaround is to use an xquery expression that disables streaming: e.g. instead of '/a/b/c' something like '/*[local-name()='a']/b/c'.  That should only be done of course if the parsed foot print of the document is relatively small. Added: https://issues.jboss.org/browse/SOA-3559

There is a performance degradation in select queries from XML datasource. The workaround is to use an xquery expression that disables streaming (in other words, instead of '/a/b/c', use something like '/*[local-name()='a']/b/c'.)  Only do this if the parsed footprint of the document is relatively small.
Comment 10 David Le Sage 2011-11-15 00:45:49 UTC 
Documented as known issue for the RNs.