[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1463) limit buffering for large results

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1463.
-----------------------------------

        Labels: performance  (was: )
    Resolution: Done


non-cached forward-only results will limit their buffers to 20 batches and block until the client pulls more results.  If client processing of results lags for large results, there is a potential for resources to be held open - but disk resources will not be proactively consumed, which can be problematic in million row scenarios.

> limit buffering for large results
> ---------------------------------
>
>                 Key: TEIID-1463
>                 URL: https://issues.jboss.org/browse/TEIID-1463
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>              Labels: performance
>             Fix For: 7.4
>
>
> In a forward only scenario, if a client lags behind the server a buffer will still be built containing much of result.  It would be good to limit the buffer size and prempt proactive processing when exceeded.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira