[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=12641258#comment-12641258 ] 

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

>From an initial investigation I would estimate that that there is about a 10% overhead (depending upon the document and types used) when running a streaming query vs. non-streaming.  This is due to using an intermediate tuplebuffer and xom/nux.  However there are no obvious hotspots.  The rest of the overhead in a client/server scenario is likely from the increased latency of streaming processing - results are not returned until the document has been fully processed.  Changing results processing to be multi-threaded would be the next step.
                
> 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