title: Hibernate pagination : ScrollableResult vs. setMaxResult() + setFirstResult()
body: <p>I've been using ORM frameworks for a while but I am rather new to Hibernate, though.</p>
  
  <p>Suppose you have a query (is it a Query or a Criteria, does not matter) that retrieves a great result set and that you want to paginate though it. Would you rather use the setMaxResult() and setFirstResult() methods combo, or a ScrollableResult?</p>
  
  <p>Which is the best approach regarding the performances (execution time AND memory consumption)?</p>