What is pagination?

Pagination is a method of dividing a large volume of data into pages for easier viewing and processing. Instead of loading and displaying all records at once, the data is split into parts (pages), and the user can navigate between them.

For example, in a web application with a product catalog, pagination allows showing 20 products per page instead of all 1000 at once. This improves performance and usability.

Typical pagination parameters:

• Page number (page)
• Number of items per page (limit or pageSize)

Example of a SQL query with pagination:

SELECT * FROM products ORDER BY id LIMIT 20 OFFSET 40;

Here, OFFSET 40 means skipping the first 40 records, and LIMIT 20 means taking the next 20.