Although database properties, dialect, and mapping files are the most important parts of a Hibernate configuration file, Hibernate's configuration properties include far more than what you have seen so far. This section discusses some of these configuration properties.
These properties relate directly to the
java.sql.Statement objects, which Hibernate uses behind the scenes to interact with the database:
hibernate.jdbc.fetch_size:This property specifies the number of database rows that are buffered with every fetch. Using this property can improve performance when the application retrieves many rows. The optimized value can be achieved by balancing memory usage and network ...