SQLAlchemy supports update batching using Cursor.executemany().
Sadly, executemany in PyMySQL (and mysqlclient) only support INSERT and REPLACE
query.
I'll add new executemany implementation which uses multi results.
While it doesn't reduce number of queries, it can reduce number of roundtrips.
SQLAlchemy supports update batching using
Cursor.executemany().Sadly,
executemanyin PyMySQL (and mysqlclient) only support INSERT and REPLACEquery.
I'll add new
executemanyimplementation which uses multi results.While it doesn't reduce number of queries, it can reduce number of roundtrips.