setMaxResults
is the same as LIMIT
in SQL- you are setting the maximum number of rows you want returned. This is a very common use case of course.
setFetchSize
is about optimization, which can change how Hibernate goes about sending the results to the caller (example: buffered, in different size chunks).
setFetchSize
is NOT implemented by all database drivers.