Web icon

Advanced Query Optimized Pagination

Stable version 1.0.1 (Compatible with OutSystems 11)
Uploaded on 10 January 2020 by 
 (2 ratings)

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.

Release notes (1.0.1)

Added the Anonymous permission to the Web Screen List ListWithFilters.

Reviews (0)
Related assets
More from Ricardo Monteiro