Search the community

Deep-offset latency versus lost random access: choosing between Offset and Keyset pagination in Hibernate

The Concrete Constraint A Hibernate-based application must paginate a table expected to grow into the millions of rows. Two documented approaches are available, and the unresolved decision is which one fits a workload where users routinely navigate deep into the result set while concurrent inserts continue. Option A: Offset-based pagination Using Query.setFi

jeethibernatejavaRahul Cedar0 rep · 21 Aug 2022, 03:09 UTC