Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
2.0.13
-
None
-
None
-
None
-
Linux64 & Windows64
Description
MariaDB ODBC driver/connector accepts array insert (SQL_ATTR_PARAMSET_SIZE) via an ODBC application. However, when we tested, it turns out that it actually sends data row by row to the connected Aurora (or MySQL) database. Due to this, we are hardly able to see any performance improvement using array insert compare to non-array (row-by-row) insert.
Apparently we are seeing same behavior with latest MySQL ODBC driver/connector as well (v5.3.7) and we've raised similar bug against them as well (Bug #85266).
Attachments
Issue Links
- duplicates
-
ODBC-86 Optimize Array Insert
- Closed