Architecture Principles

Core Principles

During batch queries, JDBC leverages the cursor traversal capability of GaussDB Kernel to obtain a specific number of rows of data from the database server. This number is predetermined. The database server then returns result data to JDBC in batches based on the specified number until all query results are returned.

Solution Advantages and Disadvantages

1. During batch queries, the database returns a specific number of rows of data each time. This helps prevent memory overflow in Java applications when dealing with large result sets.
2. Batch queries involve multiple interactions with the database network, which can lead to a certain level of performance loss.