[ 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)