[ https://issues.apache.org/jira/browse/IGNITE-11499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16820996#comment-16820996 ]
Yury Gerzhedovich commented on IGNITE-11499: -------------------------------------------- [~tledkov-gridgain], just one minor comment [ConnectionPropertiesImpl.java|https://github.com/apache/ignite/pull/6381/files#diff-815dbcdf24e2a2b4fc9c2236ca20a4c9] - need to amend javadoc for updateBatchSize field. > 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 > Assignee: Taras Ledkov > Priority: Major > Fix For: 2.8 > > Time Spent: 20m > Remaining Estimate: 0h > > 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 > # Add it to other languages -- This message was sent by Atlassian JIRA (v7.6.3#76005)