[IGNITE-11341] SQL: Enable lazy mode by default

• Type: Task
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Component/s: sql
• Labels: h2-limitation
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Vladimir Ozerov
• Created: 17/Feb/19 15:56
• Updated: 10/Feb/23 10:37
• Resolved: 10/Feb/23 10:37

Description

We redesigned lazy mode, so that now it doesn't spawn new thread and has the same performance as old "eager" mode (IGNITE-9171). However, we didn't enable it by default because H2 1.4.197 contains several bugs causing query engine slowdown in some cases when lazy mode is set. These issues are resolved in H2 master and will become available as a part of the next release (presumably 1.4.198).

We need to make lazy mode enabled by default once new version is available (IGNITE-10801).

Issue Links

• blocks: IGNITE-9791 Document: SQL query lazy mode is used by default
• is blocked by: IGNITE-10801 Upgrade H2 version up to 1.4.199
• is cloned by: IGNITE-18719 [IEP-80] Deprecate lazy flag of SqlFieldsQuery
• is related to: IGNITE-9171 Use lazy mode with results pre-fetch