[CONPY-165] Optimize executemany() for non MariaDB servers Created: 2021-09-23 Updated: 2023-06-28 |
|
| Status: | Open |
| Project: | MariaDB Connector/Python |
| Component/s: | DBAPI 2.0, Performance |
| Affects Version/s: | 1.1.0b1 |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Georg Richter | Assignee: | Georg Richter |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||||||
| 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. |