Demo optimized advance sql with Paging

Stable Version 1.0.0 (OutSystems 10)
Published on 22 November 2018 by 
Created on 22 November 2018

Demo optimized advance sql with Paging

Documentation

In case of paging with Table Record, Aggregates fetching records according to line count from database but in case of advance sql it is fetching all records from database every time. In this demo I done the implementation so that advance sql is also fetching data as per line count of table record(same way Aggregates in case of paging). It will improve the performance of advance sql.


Example: If line count is 10

1.  Page load Aggregates will fetch 11 records, 2nd page fetch 11+10=21 records and so on

2. In Advance sql in every case it fetch all records, So in this demo advance sql in optimized to behave like aggregates 


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 Shashikant Shukla who created this component.
Dependencies
Demo optimized advance sql with Paging has no dependencies.