Telerik Grid DataBind performance issue

[Raj Kamal]

We have nearly 160+ records in Telerik Grid added to aspx page and if the number of records in the database is going to be increased, it is taking lot of time to execute the DataBind() method executing line even though the SP is getting the data in less time. Please let us know the reason for this Telerik Grid behaviour and also the solution, if any to resolve this...

 

 Regards:

Ravi Chandra.D

[Viktor Tachev]

Hello Ravi,

Note that the DataBind() method for RadGrid is used for simple data binding. As the name implies this type of binding is suitable only for the most simple scenarios.

For most scenarios it is recommended to use advanced data binding. You can bind the grid to a declarative DataSource control or use the NeedDataSource event to provide the data.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/data-binding/understanding-data-binding/server-side-binding/declarative-datasource
• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/data-binding/understanding-data-binding/server-side-binding/advanced-data-binding-%28using-needdatasource-event%29

In order to further improve performance you can use custom paging.

• http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/paging/custom-paging/defaultcs.aspx

For additional performance optimization techniques please check out the following article.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/performance/grid-performance-optimizations

Regards,
Viktor Tachev
Telerik