Advanced Query Optimized Pagination

Stable Version 1.0.1 (OutSystems 11)
Published on 10 January 2020 by 
Stable Version 1.0.1 (OutSystems 11)
Published on 10 January 2020 by 
Created on 05 December 2019

Advanced Query Optimized Pagination

Advanced query optimized to fetch only the results to show on a list.
Read More

Huge data with paging has been a big headache for the developer. There is a default paging option available with some data controls. These controls do manage paging automatically without writing so much code but provide poor performance. This default paging is handled at the page level (in the .Net environment) and consumes memory. Few known techniques have been impaired with these controls to enhance the performance. But they still give bad performance over custom-paging.

In this sample, you will see how to use the SQL Server OFFSET FETCH clauses to limit the number of rows returned by a query and apply to a Table Records and still keep all the OutSystems UI widgets.

What’s new (1.0.1)

Added the Anonymous permission to the Web Screen List ListWithFilters.

Reviews (0)
Development tools, Database
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Ricardo Monteiro who created this component.
See all 3 dependencies
Component Consumers
No consumers yet.
Weekly Downloads