[teiid-issues] [JBoss JIRA] Commented: (TEIID-1750) Memory handling improvements
[
https://issues.jboss.org/browse/TEIID-1750?page=com.atlassian.jira.plugin...
]
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