Telerik Grid - Paging Issue

[Minesh Doshi]

Hello,

I want to show 10 records out of 100,000 records from database using telerik grid.

So, i am plannint to use telerik grid's inbuild paging.
Now, the issue is if i need to use telerik paging, i must have 100,000 records with me. So, my sql query will take too much time as i will get 100,000 records for paging.

Can i pass argument to fetch 10 records and it takes only 10 records from database and manage paging too in telerik-grid??

Note: i will also use telerik grid's filtering and sorting too. So, the solution should support paging as well as filtering and sorting.

Please suggest.

Thanks.

[Shinu]

Hello Himanshu,

Take a look at the following help article.
Client/server grid performance optimizations.
Custom paging.

Thanks,
Shinu.

[Minesh Doshi]

Hi Shinu,

Yes, the below link helped me to create custom filtering/paging/sorting.

Thanks for the help.