Almost all web applications use pagination to split large tables into pages with
a relatively small number of rows each. In Toplink Essentials, setFirstResult()
and setMaxResults() can be used to achieve this.
At least for PostgreSQL and MySQL, and most likely for other RDBMs, a lot of I/O
effort can be saved by using the LIMIT and OFFSET sql clauses. Toplink
Essentials really should use it!!
(Hibernate has been doing this for a long time!!)