[teiid-issues] [JBoss JIRA] (TEIID-1813) EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource

[Steven Hawkins (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12640844#comment-12640844 ] 

Steven Hawkins commented on TEIID-1813:
---------------------------------------

It does seem that this is situation 1 above since a view is being used.  In which case the previous (5.2 er3) results were likely in error.  The 5.1 results should be representative, but possibly do not represent proper use of projection/streaming and thus would be prone to OOM errors with larger documents and higher query loads.  

We certainly can look at improving performance, but I take exception to the idea that a marginal performance issue in just one execution path of an extremely large product would constitute a blocker at this stage.  It seems like a break down in process.  My recommendation is to target this for an sp1 or patch rather than holding up the release.
                
> EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource 
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1813
>                 URL: https://issues.jboss.org/browse/TEIID-1813
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 7.4.1
>            Reporter: Pavel Macik
>            Assignee: Van Halbert
>            Priority: Blocker
>         Attachments: perf.vdb
>
>
> 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 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira