TDSQL Boundless has limits on transaction size. Exceeding these limits will cause data write operations to fail with an error:
The size of an inserted single row needs to be controlled within tdstore_xn_max_entry_size (default is 64MB).
The total size of a single transaction needs to be controlled within tdstore_max_txn_size (default is 1GB).
The total size of all running transactions needs to be controlled within tdstore_total_running_txns_size (default is 3GB).
When batch operations on data are performed, the program must have interrupt handling capability, a transaction failure retry mechanism, and the ability to handle pending situations such as timeouts.