I agree with your answers, but I feel that hitting database for each 100 records is also a costly process.
I google for pagination and found display tags third party API, don't know in what way it is functioning internally. It seems like it is getting all the available records from database and displaying in the browser
Is there any thrid party API which functions as per your explanation, like fetching only 100 or 1000 records per page each time?
Thanks again.
Sai