very slow when pagination,sorting, filtering in radgrid

[vinoth sansar]

Dear All,

          Am using radgrid, using dataset fill the grid. i need more than 1 lakhs records to display. My pagesize of rad grid is 5. It is very slow when loading grid then after change the 2nd page then its take too time. every action in grid its take time.

So i want to take first  10 records on load grid and then second page  then load another 10 records from database. how to customize in the radgrid. I think rad grid load 1 lakhs record every time from database but user only need 10 or 20 records or some other thing.

If i set pagesize is 10 then radgrid load only 10 records from database, if i change 50 records then grid load 50 rows only load from DB.
please provide with right example. thanks.

[Pavlina]

Hi Vinoth,

Can you please share with us approximately how many items you display in the grid? In case you display very large amount of records in the control, you may consider using custom paging or taking advantage of the LINQ queries support of RadGrid (under .NET 3.5) to speed up the performance as much as possible. This should reduce the loading time of the control to a great extent.

Other useful tips about how to optimize the overall performance of RadGrid for ASP.NET AJAX you can find in these online resources:

http://www.telerik.com/help/aspnet-ajax/gridoverview.html (Chapter "Performance tips and tricks")
http://www.telerik.com/products/aspnet-ajax/resources/top-performance.aspx
http://www.telerik.com/support/aspnet-ajax/grid.aspx (section "Performance")

Kind regards,
Pavlina
the Telerik team

[vinoth sansar]

Hi Pavlina ,

Thanks for your reply. Its very useful. But i can implement for custom paging only. For custom page its working properly.

I need for sorting and filtering also. For sorting and filtering its all list from the database. I need a list what users going to see in the grid page. Can u please  provide an example..

thanks,
vinoth

[Pavlina]

Hi Vinoth,

Please try setting the CanRetrieveAllData property of RadGrid's MasterTableView to false. Thus  you will get only the items for the current page exactly the same as you would with MS' GridView control.

Give this suggestion a try and see if it helps.

Sincerely yours,
Pavlina
the Telerik team