Home / Questions / 5151
Accepted
hecnabae
Asked: 2020-03-04 07:06:51 +0800 CST 2020-03-04 07:06:51 +0800 CST

What is the difference between setMaxResults and setFetchSize in org.hibernate.Query? (Translation)

  • 772

What is the difference between the org.hibernate.Query method setMaxResultsand the setFetchSizeorg.hibernate.Query method?

You can see the original question here .

java

1 Answers

  1. Best Answer

    setMaxResults has the same effect on the query as it does LIMITin SQL , that is, it limits the maximum number of rows that the query returns.

    setFetchSize has more to do with optimization, since it allows you to tell Hibernate how to return the data in blocks of information (all the records at once, or blocks of n records as we need to access the data). Note that setFetchSizeit is not implemented for all database drivers.

    You can see the original answer here

    • 2