Register / Login
JDBC and Relational Databases
Sql Jdbc Pagination
friki data migration
posted 11 months ago
pagination for large results
Most databases support some way of paging ordered results through LIMIT .. OFFSET, TOP .. START AT, OFFSET .. FETCH clauses. In the absence of support for these clauses, there is still the possibility for
ROW_NUMBER() OVER() filtering (DB2, SQL Server 2008 and less)
, which is much faster than paging in memory. This is specifically true for large offsets!
Just use those clauses, or a tool (such as
) that can simulate those clauses for you.
jOOQ is the Best and an Increasingly Popular Way to Write SQL in Java
Sql Window Functions
Sql Sorting Java Memory
Sql Processing Java Memory
Sql Union All