Fetch by batch
@Repository
public interface PostRepository extends Base]paRepository<Post, Long> {
@Query("'" select p from Post p
where date(p.createdon) >= :sinceDate
@QueryHints(
@QueryHint (name = AvailableHints. HINT_FETCH_SIZE, value = "25")
Stream‹Post> streambyCreatedonSince(@Param("sinceDate") LocalDate sinceDate);
} The FETCH_SIZE JPA query hint is necessary for PostgreSQL and MySQL to instruct the JDBC Driver to prefetch at most 25 records. Otherwise, the PostgreSQL and MySQL JDBC Drivers would prefetch all the query results
prior to traversing the underlying Resultset.