[jira] [Updated] (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 ] Vladimir Ozerov updated IGNITE-4370: Labels: important (was: 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)
[jira] [Updated] (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 ] Vladimir Ozerov updated IGNITE-4370: Fix Version/s: (was: 2.0) 2.1 > 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 > 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)
[jira] [Updated] (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 ] Vladimir Ozerov updated IGNITE-4370: Assignee: (was: 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 > Labels: odbc > 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)