Bug 781071 (SOA-3559) - EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource
Summary: EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA ...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3559
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: Performance, EDS
Version: 5.2.0.ER4,5.2.0.ER5,5.2.0.ER6
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:
TreeView+ depends on / blocked
 
Reported: 2011-11-07 09:29 UTC by Pavel Macik
Modified: 2011-12-12 16:08 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-12-12 16:08:12 UTC
Type: Bug


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3559 0 None Closed EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource 2012-03-13 14:23:06 UTC
Red Hat Issue Tracker TEIID-1813 0 None Closed EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource 2012-03-13 14:23:06 UTC

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.


Note You need to log in before you can comment on or make changes to this bug.