Architecture Principles

Core Principles

When the UseBatchProtocol and UseServerSidePrepare parameters are enabled, batch processing of ODBC can reuse the same execution plan for a prepared SQL statement. All batch data to be committed within the current transaction is carried in a single U packet. Consequently, completing the batch operation only necessitates once instance of network connection establishment and data exchange.

Solution Advantages

• Optimized network communication

  Sending all batch updates at once in a single U packet significantly decreases network communication overhead when compared to sending PBE packets multiple times.

• Improved execution efficiency

  Due to the reduced number and frequency of network communication, the overall execution efficiency is significantly improved, especially for large data sizes.

• Optimized resource utilization

  Batch insertion optimizes the utilization of database server resources, cutting down on unnecessary system overhead associated with single-record insertion.