DEV Community

Discussion on: The SQL I Love. Efficient pagination of a table with 100M records

lluismf profile image
Lluís Josep Martínez

What's your method of scanning large tables?

We have no use cases where scanning large tables is needed. At least in the UI. We return the first page, then second page (skipping the first) and so on. End users end pagination after a few pages => they must refine the query.

For backend processes we just use a ResultSet, but there's no need to paginate, obviously.