[ 
https://issues.apache.org/jira/browse/IGNITE-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16605701#comment-16605701
 ] 

Taras Ledkov commented on IGNITE-9480:
--------------------------------------

[~vozerov], please take a look at the suggested [H2 
patch|https://github.com/h2database/h2database/pull/1424] .

> SQL: Introduce H2 LocalResult factory
> -------------------------------------
>
>                 Key: IGNITE-9480
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9480
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 2.6
>            Reporter: Taras Ledkov
>            Assignee: Taras Ledkov
>            Priority: Major
>             Fix For: 2.7
>
>
> H2 collects query result at the instance of `LocalResult` for queries results 
> that not be gathered lazy. This causes an OOME error on large result sets.
> We have to introduce way to use our own implementation of the query result's 
> container.
> Suggestion fix:
> - H2 simple refactoring: make `LocalResult` interface and H2 default 
> implementation `LocalResultImpl`
> - Add H2 configurable `LocalResultFactory` to setup custom implementation of 
> the `LocalResult.
> - Create Ignite implementation of `LocalResultFactory` & `LocalResult` to 
> track allocated memory, swap results to external storage etc.
> H2 issue: 
> [#1405|https://github.com/h2database/h2database/issues/1405#issuecomment-417631253]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to