I am looking for a technical term (or phrase, or something concise) that describes the process of limiting the number of records returned from a query through the use of OFFSET
and LIMIT
.
For example, I have an application that displays a bunch of records in a table. If I do something naive like this
SELECT * FROM table
It might be slow, especially if there are millions of records, so I optimize my application by using a paginated user interface that will display 50 records at a time. So for example, I want to get records 101 to 150 because the user decided to go to page 3, I might say something like
SELECT * from table LIMIT 50 OFFSET 100
I don't know what kind of words I should be using to describe my design decisions so that others will immediately understand what I'm doing.