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
4 Answers, 1 is accepted
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
Rank 1
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
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
Rank 1
Hi Dess,
I will look into it.
Thanks and best regards,
Dominic