[ODBC-86] Optimize Array Insert Created: 2017-03-02  Updated: 2023-04-13  Resolved: 2023-04-13

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 2.0.13
Fix Version/s: 3.2.0

Type: Task Priority: Major
Reporter: kriti suwalka Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by ODBC-89 Array insert performance is same as n... Closed

 Description   

We are trying to use array insert feature of ODBC driver but we are observing strange behavior. Our sample ODBC code achieving array insert seems to be correct as ODBC trace does show the correct behavour however when we check slow query logs at server,each row is seen inserted individually. Which is leading performance issues.
We are having 10K rows and having SQL_ATTR_PARAMSET_SIZE set to 1000. ODBC trace shows 10 SQLExecute statements which is fine but slow query logs at server shows single row insert(10k entries for insert statement).

 Comments   
Comment by Lawrin Novitsky [ 2017-03-02 ]

There is no bug here, but some optimization is possible

Comment by Lawrin Novitsky [ 2023-04-13 ]

3.1 already has parameter array support with binary protocol with MariaDB servers. 3.2.0 brings possibility of traditional batching of statements using CSPS and text protocol

Generated at Thu Feb 08 03:26:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.