[
https://issues.apache.org/jira/browse/IGNITE-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16050412#comment-16050412
]
Igor Sapego commented on IGNITE-4370:
-------------------------------------
[~ptupitsyn], can you also have a look?
> 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.4.14#64029)
