One suggestion is that you can use CustomPaging which fetch only a fixed number of records and perform operations on this limited set of data. Check the following help documentation which explains how to implement CustomPaging. Custom Paging
Thanks for your quick reply,
Want to ask how to handle dynamic datasource in case of custom paging.
I can manage filter and sorting on dataset but unable to handle startindex and Maxindex.