[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

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