ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-4370) ODBC: Implement DML operations with parameters in batch.
Date Thu, 15 Jun 2017 13:56:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16050522#comment-16050522

ASF GitHub Bot commented on IGNITE-4370:

Github user isapego closed the pull request at:


> 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

View raw message