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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot