Performance issue with lot of columns

[Julien Barach]

Hi,

There is a performance issue when a grid has a lot of columns. In my case there can be up to 300 columns.

But the grid is too slow and freezes the whole page even with simple datasource with few rows.

I've made a simple repro with 100 columns so that you can test it. It's slow when navigating on the page, and clicking multiple times on the counter is slow to render.

In a more complexe page even 40 columns is too slow to be used.

What can be done to improve performances ?

Attachment: BlazorAppSlowGrid_dbc53547.zip

[Balamurugan Lakshmanan]

Hi Julien,

Greeting from Syncfusion Support.

To enhance the performance efficiency of your application, even with large datasets, we recommend using either paging or virtualization. These techniques can help to minimize the load on your application and enhance its overall performance.

Additionally, we suggest rendering the page size with a minimum page size for better performance. For further information and guidance, please refer to the attached user guide.

Reference: https://blazor.syncfusion.com/documentation/datagrid/webassembly-performance

Regards,

Bala

[Andre Putz]

Hi Balamurugan,

What do you suggest me when using the grid in the batch mode, for this same situation about performance with many columns?

I am asking this becuase when I used paging or virtualization for example, I saw that all changes made on the page are lost when you move to another page.

Another issue that I have, is that I have calculations cells that is calculated with other cells and another rows, so imagine that you are updateting some cell at row 55 at page 2 and you are inputing data at row 5 at page 1. So the user needs to navigate to the next page and when he does that, he looses the data inputed at previous page.

I can't obligate him to save data before change the page, because he might be want to cancel the changes.

[Balamurugan Lakshmanan]

Hi Andre,

Before proceeding further with your requirement, we need some more clarifications from your end. kindly share the below details to proceed further at our end.

1. Share us the entire Grid code snippet.
2. Kindly explain your requirement elaborately for better understanding.

3. Share us a video demonstration of the issue.
4. If possible kindly share us a simple issue reproduceable sample .

Above requested details will be very helpful in validating the reported query at our end and provide solution as early as possible.

Regards,

Bala