Look for the section "Pagination with ROWNUM" about half way down.
Tim Cooke wrote:As a side note: I would seriously question the value of presenting over 5000 records on the UI, paginated or not. No user is going to look at every single one.
That's the reason for pagination, surely?
So you're only displaying a subset of the results.
That's what Google does, after all.
I'm not associated with the product, I just use it a lot.
Bear Bibeault wrote:I'd suggest only retrieving as many rows as you are yogin to display. Why fetch 5000 rows if you are only going to show 100? There are SQL clauses to "slice" the data that is returned by the result set (depends upon database), and JPA methods to do the same.
Which is exactly what the Ask Tom page I linked to shows you how to do.
Attempting to show everything is a short hop from a padded room and a coat with long arms.