Requirement: I have a table with source as a D page. This D page returns 800+ records which reduces the performance. Source for this D page is an Activity which has calculations based on the data for every record. (Basically looping through the above 800 records and performing calculation while displaying then onto the UI)
Solutions tried: Added pagination to display 10 at a time. But at the backend its calculating and keeping the data ready for all 800 records.
How can we restrict it to have the calculations done for only 1st 10 records and then when user clicks on next page he fetches for the next 10 records?
Pagination activity is a related solution, but in UI Gallery the OOTB activity "pxAdvancedPaginateForEmployees" has the listview.
@TejaswiniC Do you need to calculate whole data set on loading of the grid? not sure your requirement will support or not, but you can think about preload the entire data in templist or your d page before landing to the screen.
or load the d page by using defer load option in dynamic layout where you are using your table.