tdsql_bulk_commit_records is used to set the threshold number of data entries that meet the commit conditions for sub-transactions split during the DDL process. When this limit is reached, the system automatically commits transactions to free up space for new records.tdsql_bulk_commit_records parameter, you need to consider the following factors:tdsql_bulk_commit_records parameter may improve the performance of batch insert, update, and delete operations. However, an excessively large value may cause transactions to become too large, which can affect system performance and stability.tdsql_bulk_commit_records parameter. If a performance bottleneck is identified, you can try adjusting this parameter to optimize performance.Required | Description |
Parameter Type | ULONG |
Default Value | 3000 |
Value Range | 1 ~ 18446744073709551615 |
Effective Scope | GLOBAL SESSION |
Restart Required | No |
피드백