Updated on 2025-09-04 GMT+08:00

Requirements and Objectives

Service Pain Points

When dealing with large data sizes, single-record insertion generates numerous network requests and consumes substantial system resources. Moreover, the database server has to repeatedly parse similar statements, leading to a decline in service performance. Batch insertion is introduced as a solution to these issues.

Service Objectives

Use the ODBC driver to initialize the target table, and insert the required data in batches through transactions for future queries. Compared to inserting data individually through SQL statements, this approach decreases interactions with the database and alleviates the database load.