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

Optimize Array Insert

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

          is duplicated by

          Task - A task that needs to be done. ODBC-89 Array insert performance is same as non-array insert connecting to Aurora database

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Lawrin Lawrin Novitsky added a comment -

            There is no bug here, but some optimization is possible

            Lawrin Lawrin Novitsky added a comment - There is no bug here, but some optimization is possible
            Lawrin Lawrin Novitsky added a comment -

            3.1 already has parameter array support with binary protocol with MariaDB servers. 3.2.0 brings possibility of traditional batching of statements using CSPS and text protocol

            Lawrin Lawrin Novitsky added a comment - 3.1 already has parameter array support with binary protocol with MariaDB servers. 3.2.0 brings possibility of traditional batching of statements using CSPS and text protocol

            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.