Upgrade your indoor air quality with our Floor Return Air Grille with Filter. This innovative grille combines efficient air circulation with filtration capabilities, helping to remove dust, allergens, and other airborne particles from your indoor environment. Ideal for residential and commercial spaces, this grille is designed to fit seamlessly into your floor, providing a discreet and effective solution for improving air quality. With its durable construction and easy-to-replace filter, this grille ensures long-lasting performance and hassle-free maintenance. Breathe easier and enjoy cleaner air with our Floor Return Air Grille with Filter.
@Repository
public interface PostRepository extends BaseJpaRepository<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.
M. Variščić. Udruženje za zaštitu okoline Zeleni - Neretva ; Fondacija Heinrich Böll, Regionalni ured Sarajevo, Konjic ; Sarajevo, Third edition, (2011)