Default Fetch Size in MyBatis Queries: Explanation and Customization

Answered using GPT-4o-mini by Java Q&A Hub

Question:

What is the default fetch size used by MyBatis when executing queries?

Answer:

In MyBatis, the default fetch size when executing queries is typically set to 0. This means that the driver will use its default fetch size, which can vary depending on the database and JDBC driver being used.

If you want to specify a custom fetch size, you can do so in your MyBatis configuration or directly in your mapper XML files by using the fetchSize attribute in your SQL statements. For example:

<select id="selectExample" resultType="ExampleType" fetchSize="100">
    SELECT * FROM example_table
</select>

This would set the fetch size to 100 for that specific query. Adjusting the fetch size can help optimize performance based on the specific use case and the characteristics of the data being retrieved.