This is a migrated thread and some comments may be shown as answers.

very slow when pagination,sorting, filtering in radgrid

3 Answers 565 Views
Grid
This is a migrated thread and some comments may be shown as answers.
vinoth sansar
Top achievements
Rank 2
vinoth sansar asked on 21 Sep 2010, 06:19 AM
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.

3 Answers, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 21 Sep 2010, 12:31 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
vinoth sansar
Top achievements
Rank 2
answered on 15 Oct 2010, 12:16 PM
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
0
Pavlina
Telerik team
answered on 18 Oct 2010, 05:10 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
vinoth sansar
Top achievements
Rank 2
Answers by
Pavlina
Telerik team
vinoth sansar
Top achievements
Rank 2
Share this question
or