Query.getResultList(): one million records ?

[javatwo]

Suppose I have a large database table with one million records. When I call Query.getResultList() that will return all the one million records, and display them in web browser through page navigation (like, 1, 2, 3, ..., next page). How is the one million records managed? all in memory? on-demand? Thanks. Dave

[epbernard]

Don't do that.
Use pagination
query.setFirstResult(300).setMaxResult(20).getResultList()

[javatwo]

Thanks. great!