Uploaded image for project: 'MariaDB Connector/Python'
  1. MariaDB Connector/Python
  2. CONPY-165

Optimize executemany() for non MariaDB servers

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.1.0b1
    • None
    • DBAPI 2.0, Performance
    • None
    • 3.6 - 3.9

    Description

      When connecting to a database server which doesn't support bulk execution commands are executed in a loop row by row.

      While this is ok for DELETE and UPDATE commands, REPLACE and INSERT should be optimizied by rewriting the statement and using multi value syntax.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONPY-267 Behavior of executemany() is inconsistent between MariaDB and non-MariaDB servers

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26673 COM_STMT_EXECUTE (bulk) returns error on INSERT .. SELECT ....

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONPY-267 Behavior of executemany() is inconsistent between MariaDB and non-MariaDB servers

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. CONPY-266 Make executemany() faster on non-MariaDB servers

          • Major - Major loss of function.
          • Open

          Activity

            People

              georg Georg Richter
              georg Georg Richter
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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