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

Optimize executemany() for non MariaDB servers

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.1.0b1
    • Fix Version/s: None
    • Component/s: DBAPI 2.0, Performance
    • Labels:
      None
    • Python Version:
      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

            Activity

              People

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

                Dates

                Created:
                Updated:

                  Git Integration