Paging
Paging a dataset: page size, navigation controls, and keeping listing UIs responsive and fast.
Introduction
Section titled “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)
Section titled “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
Section titled “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
Section titled “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
Section titled “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