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

Posted to issues@ignite.apache.org by "Igor Sapego (JIRA)" <ji...@apache.org> on 2017/06/02 13:45:04 UTC

[jira] [Assigned] (IGNITE-4370) ODBC: Implement DML operations with parameters in batch.

     [ https://issues.apache.org/jira/browse/IGNITE-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Igor Sapego reassigned IGNITE-4370:
-----------------------------------

    Assignee: Igor Sapego

> 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: odbc
>             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)