Teiid is performing poorly in case of UPSERT large no. of rows, the connector is mysql in my case.
For merging large no. of rows, Teiid is not considering the batch size provided by me, instead it is considering the whole operation as a single transaction.
Thus, the only solution remain in my case is to increase transaction timeout, which is to be configured considering the number of rows to be merged.
Is there any alternative to this? Can Teiid perform UPSERT same as INSERT does and take less time to complete. Also can the UPSERT operation be divided into batches?
Thanks in advance.
Retrieving data ...