GridComboBoxColumn with many items as data source very slow in SfDataGrid

[Michael Witzik]

Hello,

I try to use a SfDataGrid with a GridComboBoxColumn. I like to fill the DataSource for this Column with a DataTable with a large count of items (10000+). The problem is, that the form hangs upon loading and the grid gets unusable when opening the dropdown of this column. I would like to use the "suggest" feature of the ComboBox, but it is not possible because of the very slow performance.

I think this is because the grid uses a older version of the ComboBox. In the toolbox of Syncfusion I can see two version of the ComboBox - SfComboBox and ComboBoxBase. When I put the SfComboBox on a form and fill it with 10000+ items, the selection and also the suggest feature works very fast. But when I use a ComboBoxBase and add 10000+ items, it is very slow. My feeling is, that the GridComboBoxColumn also uses the ComboBoxBase version?

Is it possible to change the control used in the GridComboBoxColumn or to make it faster and usable with a large amount of dropdown items?

Thank you.

Michael

[Vijayarasan Sivanandham]

Hi Michael Witzik,

Thank you for contacting Syncfusion Support.

Currently, we are analyzing your requirement of “GridComboBoxColumn with many items as data source very slow in SfDataGrid” We will validate and update you the details on or before MAy 03, 2021.

We appreciate your patience until then.

Regards,
Vijayarasan S

[Vijayarasan Sivanandham]

Hi Michael Witzik, 

Thank you for your patience.   

We are still working on this. We will update with further details on or before May 05, 2021. We appreciate your patience and understanding.

Regards,
Vijayarasan S 

[Vijayarasan Sivanandham]

Hi Michael Witzik,

Thank you for your patience.

We have created bug report for the reported issue. We will fix this issue and include in our May 25th ,2021 NuGet release.

We will update the feedback link for this bug on 06^th May 2021.

We appreciate your patience until then.

Regards,
Vijayarasan S 

[Vijayarasan Sivanandham]

Hi Michael Witzik,

Thank you for your patience.

We have created bug report for the reported issue “Slow loading and UI hang sometimes when large data set in DataSource of GridComboBoxColumn in SfDataGrid”. We will fix this issue and include in our May 25th ,2021 NuGet release.

You can track the status of this report through the following feedback link,

Feedback Link: https://www.syncfusion.com/feedback/25084/slow-loading-and-ui-hang-sometimes-when-large-data-set-in-datasource-of 

 

Note: The provider feedback link is private, and you need to login to view this feedback.

We appreciate your patience until then.

Regards,
Vijayarasan S 

[Vijayarasan Sivanandham]

Hi Michael Witzik,

Sorry for the inconvenience caused.

You are using NuGet package version. We did not provide patch for NuGet package version. And unfortunately, we did not include this fix in this weekly NuGet.

As we promised earlier, we will include your fix in our next NuGet release which will be released on June 01st ,2021

We appreciate your patience until then. 

Regards,
Vijayarasan S

[Vijayarasan Sivanandham]

Hi Michael Witzik,

Thank you for your patience. 

We are glad to announce that our latest weekly NuGet package update version 19.1.0.66 has been is rolled out with the “Slow loading and UI hang sometimes when large data set in DataSource of GridComboBoxColumn in SfDataGrid” and is available for download.

Feedback link: https://www.syncfusion.com/feedback/25084/slow-loading-and-ui-hang-sometimes-when-large-data-set-in-datasource-of

Please let us know, if you require further assistance on this. 

Regards,
Vijayarasan S 

[Michael Witzik]

Hello,

I just like to inform, that we installed the latest version 19.2.0.44 and the problem is solved. The GridComboBox in the SfDataGrid can now handle 100000+ items as DataSource without any problems and is as fast as the normal SfComboBox.

Thank you!

[Vijayarasan Sivanandham]

Hi Michael Witzik,

Thanks for the update.

Please let us know if you have any further queries on this. We are happy to help you😊.

Regards,
Vijayarasan S