[ https://issues.apache.org/jira/browse/IGNITE-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16044345#comment-16044345 ]
Pavel Tupitsyn commented on IGNITE-4370: ---------------------------------------- Looks good to me in general (though I'm not familiar with ODBC). > ODBC: Implement DML operations with parameters in batch. > -------------------------------------------------------- > > Key: IGNITE-4370 > URL: https://issues.apache.org/jira/browse/IGNITE-4370 > Project: Ignite > Issue Type: Task > Components: odbc > Affects Versions: 1.7 > Reporter: Igor Sapego > Assignee: Igor Sapego > Labels: important > Fix For: 2.1 > > > Currently, if user wants for example to insert 20k records they need to call > {{SQLExecute}} for the 20k times. More than that, internally, we transmit and > execute the same SQL query 20k times. This is a huge overhead. We should only > transfer sql query once, transfer all the parameters in a batch and then > execute it once using some fast, possibly internal API. -- This message was sent by Atlassian JIRA (v6.3.15#6346)