Advanced Query Optimized Pagination

Stable Version 1.0.1 (Compatible with OutSystems 11)
Published on 10 January 2020 by 
5.0
 (2 ratings)

Advanced Query Optimized Pagination

Details
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)
Related Components
More from Ricardo Monteiro