Performance issue with gridmvc when we have Lakh of records

Apr 11 at 3:52 AM
Hi all,

We are facing an issue with the grid when we are having lakh of records.

Scenario is:
Let say we have 10,000 records in a database table and infront end grid page size is 10,
then page nation is created with 1000 pages(10000/10). Whenever the user clicks particular page let say page 2 then request is going to DB and fetching all the 10,000 records on top of it next 10 records are getting picked and display.

Here my concern is to fetch next 10 records only instead 10,000 records for every pagination click or Initial load.

Can anyone help on this issue ??

Thanks in advance