You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2019/03/07 06:59:00 UTC

[jira] [Created] (IGNITE-11499) SQL: DML should not use batches by default

Vladimir Ozerov created IGNITE-11499:
----------------------------------------

             Summary: SQL: DML should not use batches by default
                 Key: IGNITE-11499
                 URL: https://issues.apache.org/jira/browse/IGNITE-11499
             Project: Ignite
          Issue Type: Task
          Components: sql
            Reporter: Vladimir Ozerov
             Fix For: 2.8


Currently DML apply updates in batches equal to {{SqlFieldsQuery.pageSize}}. This is prone to deadlocks. Instead, we should apply updates one-by-one by default. Proposal:
# Introduce {{SqlFieldsQuery.updateBatchSize}} property, set it to {{1}} by default
# Print a warning about deadlock to log if it is greater than 1
# Add it to JDBC and ODBC drivers



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