RadGridView schrolls schroll up or schroll down is slow or laggy

[Dominic]

Hi, I am encountering slowness or laggy when i schroll up and down when viewing different aircraft types in the gridview in my program.

I need help and suggestions on how to speed up and reduce this lag.

I have roughly more than 1,500 cells in view on the page at a time with about 10 rows (each row 1 aircraft/component type)

I have read these two articles below on cellFormatting and viewCellFormatting and have set the  e.Row.Cells(0).Tag = "UPDATED".

But the schrolling up and down is still lagging. Can anyone help me ? Thanks.

If e.ColumnIndex = 0 Then
            If e.Row.Cells(0).Tag <> "UPDATED" Then
            e.Row.Cells(0).Tag = "UPDATED"

End If

https://docs.telerik.com/devtools/winforms/controls/gridview/cells/formatting-cells?_ga=2.11009079.243279797.1583711740-1259083625.1578452304

https://www.telerik.com/forums/code-power-of-viewcellformatting

 

[Dess | Tech Support Engineer, Principal]

Hello, Dominic,

According to the provided screenshot, it seems that you have a lot of visual cell elements. We already have a know issue about performance in cases when many visual elements are created. You can track its progress, subscribe for status changes and add your comments on the following link - https://feedback.telerik.com/winforms/1371167-fix-radgridview-performance-should-be-improved-when-many-cells-are-visibile-e-g-50-rows-and-30-columns 

Is the scrolling improved if you reduce the number of visible cells in RadGridView? You can increase the columns' width and thus obtain a horizontal scrollbar. Thus, you will have the same number of visual cells elements but they won't be all visible simultaneously which is expected to improve the scrolling performance.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Dominic]

Hello Dess,
I have been testing my program as well.
I turned on the 'EnableFastScrolling' and it did improve marginally. I then turned off all all the viewcellformatting conditions as well and with some help from my colleague I found that one of the issues is also due to my datatable being too big and too much data/cells to display on the screen which cause the slow scrolling. I will be looking into other ways to reduce my datatable size and split into 2 gridviews  to speed up the process.

Thanks and best regards,

Dominic

[Dess | Tech Support Engineer, Principal]

Hello, Dominic, 

Indeed, enabling the fast scrolling is expected to improve the scrolling performance. However, two important things should be noted. If you have a lot of cell elements that are visible simultaneously on the screen, it may be affected by the previously referred feedback item related to RadGridView. The second important thing here is if you have a lot of records coming from your data base and you load the whole number of data records in RadGridView via setting the DataSource property. For such cases, it is more appropriate to use RadVirtualGrid. RadVirtualGrid is a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data. Additional information how to load data on demand in RadVirtualGrid is available in the following help article: https://docs.telerik.com/devtools/winforms/controls/virtualgrid/getting-started 

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Dominic]

Hi Dess, 

I will look into it.

Thanks and best regards,

Dominic