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