Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-89

Array insert performance is same as non-array insert connecting to Aurora database

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 2.0.13
    • None
    • None
    • None
    • Linux64 & Windows64

    Description

      MariaDB ODBC driver/connector accepts array insert (SQL_ATTR_PARAMSET_SIZE) via an ODBC application. However, when we tested, it turns out that it actually sends data row by row to the connected Aurora (or MySQL) database. Due to this, we are hardly able to see any performance improvement using array insert compare to non-array (row-by-row) insert.

      Apparently we are seeing same behavior with latest MySQL ODBC driver/connector as well (v5.3.7) and we've raised similar bug against them as well (Bug #85266).

      Attachments

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              rdhuvad Rahul Dhuvad
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.