Created on 05 December 2019
icon_unfollowing
Login to follow
aq-optimized-pagination

Advanced Query Optimized Pagination

Stable version 1.0.1 (Compatible with OutSystems 11)
Uploaded on 10 January 2020 by 
aq-optimized-pagination

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.

Release notes (1.0.1)

Added the Anonymous permission to the Web Screen List ListWithFilters.


Reviews (0)
Category
Development tools, Database
Tags
Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
See all 3 dependencies
Application Objects
Advanced Query Optimized Pagination has 8 AOs.
Team
Compatible with
Version 11
11.9.2 or higher
11.7.6 to 11.9.0
11.0.606 to 11.0.615
Database:
All
Asset consumers
No consumers yet.
Weekly downloads 
Related assets