When using JPA, if I use the setMaxResults and setFirstResult methods on TypedQuery object, seems that the framework first retrieve all query results (and creates all the corresponding objects) and than it paginate the result.

This result in perfomance issues for large database.

If I enable the setShowSql on vendor adapter, the printed query does not include the expected offset and fetch claouses.