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