[teiid-issues] [JBoss JIRA] (TEIID-3390) Improve SQL/XML generation performance and limit disk usage

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3390:
---------------------------------------

Changes include:
More cleanup - calls to the autocleanuputil from the buffer cleaner and when disk runs out we'll make a last ditch effort to clear references
Faster cleanup - persisted lobs are associated with the command that creates them and all will be removed when the command completes
Sizing adjustments - the max lob memory size will now nominally be 32KB rather than 8KB and buffer creation was adjusted to be initially small and grow on demand
Inclusion rather than inlining - up to some limits the values of subexpressions will be included rather than inlined via recopying

In total this will reduce the disk consumed and speed up processing.

> Improve SQL/XML generation performance and limit disk usage
> -----------------------------------------------------------
>
>                 Key: TEIID-3390
>                 URL: https://issues.jboss.org/browse/TEIID-3390
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> Deeply nested large xml documents generated by SQL/XML can create a lot of temporary disk backed objects.  These objects can have slow cleanup based upon when their references get cleared.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)