RADGRIDVIEW Performance Issue ?

[林]

i have a  Master-Detail CRUD Job

Details shown using RADGRIDVIEW

for example :    Master is  "TBSYUSER" class     Detail is  "TBSYUSAU"  class   

change master will change  detail data

i using   BindingList<TBSYUSAU> -->  BindingSource -> RADGRIDVIEW

now if detail data's count varing a little large

ex: record count  change from  1 to 89  due to master change

RADGRIDVIEW refresh will take more times

should i change  strucuture to :    Datatable -->  BindingSource -> RADGRIDVIEW 

or have some suggestion  ?

TKs

[Nadya | Tech Support Engineer]

Hi,

When using RadGridView in a master-detail CRUD scenario, I suppose you are creating some hierarchy based on a master-detail relation, both BindingList and DataTable are valid data sources. RadGridView can be bound to BindingList as well as to DataTables.

BindingList works well for small to medium datasets. Supports strong typing and change notifications, but large updates (e.g., 1 to 89 records) can trigger multiple refreshes, impacting performance. It is good if you need to work with custom objects and have a moderate data size.

On the other hand, DataTable is optimized for handling larger datasets. Performs better with frequent or large record updates, as it is specifically designed for tabular data and integrates efficiently with RadGridView. It is more suitable if your detailed records can grow significantly in the future or change often. For large or frequently changing datasets, DataTable is recommended for optimal RadGridView performance. From 1 to 89 records is a pretty small number of records to be shown in RadGridView, as it is capable of displaying much more. 

Each approach may have its advantages or disadvantages according to the special case that you have. I can recommend you to make a test using DataTable over BindingList and compare which one is better for your case. My assumption is that DataTables should be more suitable for such a master-detail setup. If you often have frequent changes in detailed data or your data is supposed to grow in the future, switching to DataTable can provide better performance. It is up to the developer to decide which approach to choose for their application. 

For performance improvement while updating your date, I can suggest to make use of the BeginUpdate/EndUpdate(). Regardless of data source, wrap operations (like updating the BindingList or DataTable) with BeginUpdate() and EndUpdate() to minimize UI refreshes:

this.radGridView.BeginUpdate();
// Update your data source here
this.radGridView.EndUpdate();

I hope this information helps. If you have other questions, please let me know.

Regards,
Nadya | Tech Support Engineer
Progress Telerik

[林]

HI Nadya 

"My assumption is that DataTables should be more suitable for such a master-detail setup" 

l know it's your suggestion

Then  using Microsoft EF-Core conecept to built  BindingList<T> as datasoure of RadGridView

what it's advantage ?   

Is there any solution to improver performance issue when datas are large but need to use BindingList 

if there is no solution ~  EF-Core is good option  ?

 

[Nadya | Tech Support Engineer]

Hello,

You can use EF Core concept and build BindingList<T> as datasoure of RadGridView. You can easily bind query results to a BindingList, allowing direct use of your business objects and show these data in RadGridView. It is up to you to choose the concept and exact approach to bind your grid.

At this time, we are not aware of any performance issues related to using BindingList with RadGridView. If working with BindingList<T> is your preferred approach, you can safely use it. In case you are experiencing different behavior, please prepare a sample project that reflects your exact setup and send it to me so we can perform a proper analysis.

Regards,
Nadya | Tech Support Engineer
Progress Telerik