I have been working in guidewire application version 6.0.How would you paginate an extremely large dataset in the app-server?
Example : Consider entity payment. Currently the PCF is bring back all the payments preset in the claim to the screen and the no of result to display in the UI reduced to 3 by specifying pagesize=3. Now I would like to implement the same concept through pagination in the database, via a chunking query in order increase the system stability.