[IGNITE-6080] SQL: Batch DML updates on per-node basis

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1
• Fix Version/s: 2.3
• Component/s: sql
• Labels: performance
• Assignee: Vladimir Ozerov
• Reporter: Vladimir Ozerov
• Created: 16/Aug/17 12:12
• Updated: 28/Aug/17 16:39
• Resolved: 17/Aug/17 08:26

Description

Currently DML updates are batched and then applied using IgniteCache.invokeAll. See org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor#processPage. This is not efficient, because typical update will hit a lot of data nodes.

Instead, we should create separate batches for every primary node. This way we can significantly improve update performance.

Issue Links

• links to: GitHub Pull Request #2454