To fetch range of rows and display it in repeating list.
My Requirement is , we need to fetch first 500 records and display in repeating list using pagination. If user clicks page number 491-500 through pagination , then we need to fetch another 500 records, again if user clicks page number 991-1000, then again fetch 500 records.
This basically to reduce the load of the system.We are using DB2 table from where we need to fetch records and display.
Could please guide me how to proceed the above requirement.