[teiid-issues] [JBoss JIRA] Commented: (TEIID-1750) Memory handling improvements

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1750:
---------------------------------------

Also added logic to select better batch sizes based upon the element types.  This allows for power of two batch sizes between 128 and 2048 rows depending upon the types/width of the row (that range can very based upon the base setting for processor batch size).  Planning logic is largely unaware of this distinction however.  Also object and lob typed values can produce very inaccurate estimates.

> Memory handling improvements
> ----------------------------
>
>                 Key: TEIID-1750
>                 URL: https://issues.jboss.org/browse/TEIID-1750
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.6
>
>
> The buffermanager will create softreferences for batches that prefer memory, but does not track the memory as held once the value has been passivated.
> Also small lobs, such as xml values created via sqlxml, should be inlined into results for greater performance - and so that they can be paged out by the buffermanager rather than being held by a lobmanager.

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