Paging
Paging a dataset: page size, navigation controls, and keeping listing UIs responsive and fast.
Introduction
This tour introduces paging (pagination) for large datasets and wiring paging controls to Server Connect parameters.
Use limit + offset/page
Bind next/prev controls
Paging (Pagination)
Use paging to work with large datasets efficiently. Server Connect includes tools to generate paging metadata and limit results per page.
Page large datasets efficiently
Generate paging metadata
Limit + Offset
Queries typically use a limit/pageSize and an offset/page index to fetch only the needed records.
Use a page size (limit)
Compute offset from page
Bind Paging Controls
On the page, bind paging controls (next/prev/page numbers) to your Server Connect component parameters.
Bind next/prev buttons
Bind page number controls
Next steps
Return to the Database Operations menu to continue with Queries, Insert, Update, Delete, or Paging.
Go back to Database Operations
Pick the next tour