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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Anton Vinogradov (Jira)
Igor Sapego created IGNITE-4370:
-----------------------------------

             Summary: 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
             Fix For: 2.0


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.4#6332)