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

Optimize Array Insert

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.13
    • 3.2.0
    • General
    • None

    Description

      We are trying to use array insert feature of ODBC driver but we are observing strange behavior. Our sample ODBC code achieving array insert seems to be correct as ODBC trace does show the correct behavour however when we check slow query logs at server,each row is seen inserted individually. Which is leading performance issues.
      We are having 10K rows and having SQL_ATTR_PARAMSET_SIZE set to 1000. ODBC trace shows 10 SQLExecute statements which is fine but slow query logs at server shows single row insert(10k entries for insert statement).

      Attachments

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              ksuwalka kriti suwalka
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.