[teiid-issues] [JBoss JIRA] (TEIID-5500) Improve OData performance

[Steven Hawkins (Jira)]

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

Steven Hawkins commented on TEIID-5500:
---------------------------------------

[~rareddy] See the pr https://github.com/teiid/teiid/pull/1138 - it limits the working set for an odata query to 32 pages - we can of course allow that to be set if needed.  It also returns the first page as quickly as possible (which is effective in wildfly, but does not have an effect in the jetty unit tests).  This can increase the total time of execution for large results, but it makes them better behaved.

> Improve OData performance
> -------------------------
>
>                 Key: TEIID-5500
>                 URL: https://issues.jboss.org/browse/TEIID-5500
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: OData, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.2
>
>
> See https://developer.jboss.org/thread/277783
> There is a significant overhead for OData vs. JDBC for a single client especially in terms of latency.
> We should investigate pre-building additional batch results and entity caching in general.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)