Offset pagination with SUBSELECT versus cursor-based pagination for deep Hibernate queries
We need to paginate a Hibernate query that joins a parent entity to a large child collection, returning pages of roughly fifty parents. The dataset is deep enough that later pages must avoid excessive row scanning, yet the mapping cannot be changed to a unidirectional association without losing the existing object graph. Offset-based pagination using setFirs