Slow load data on AutoComplete object in GridGroupingControl

[hieudt]

Hi,

First, thanks your team for helping me on this thread

But when data grows, more rows need to filter, more time need to return result

I can speed up a filter time, but it still slow when I enter and leave cell. How can I avoid it ? I need it do nothing when I enter and leave cell, just doing filter when I type characters, and return filtered value list

I have attached a sample for you.

Regards

Attachment: DataGrid_20201031_ef3c52c7.zip

[Balamurugan Thirumalaikumar]

Hi Hieudt, 

Thank you using syncfusion products. 

We have checked the given sample and thread at our end. Unfortunately we could not able to reproduce the issue the performance of filtering and while entering and leaving cell. Please provide us with simple sample or code customization which is useful to replicate the issue at our end.  

If you want to delay the filtering while typing characters in filter bar cell, you can use FilterDelay property. Please refer to the link UG and Video. Please let us know If we misunderstand your query. 

UG link- https://help.syncfusion.com/windowsforms/gridgrouping/filtering#setting-filtering-delay 

Video link- https://www.syncfusion.com/downloads/support/directtrac/general/ze/FilterAutoComplete-416717310.zip 

Thanks & Regards, 

Balamurugan Thirumalaikumar 

[hieudt]

Hi,

Thanks for your reply

The prolem occurs on ID column. On that column, I generate 10000 records. When I entering and leaving cell, a delay occurs, it happens when I type characters too

Regards

[Arulpriya Ramalingam]

Hi Hieudt,

Thank you for the update.

We could understand the scenario and the grid will take some time to load 10K items in the dropdown list and will be reloaded whenever the text is typed in the FilterCell to bring out the matcing items in the DropDown. The FilterDelay will allow you to type some specific text in a provided time being to avoid perfomance delay at run time. So, as we suggested earlier, we request you to FilterDelay to overcome this scenario.

UG link: https://help.syncfusion.com/windowsforms/gridgrouping/filtering#setting-filtering-delay

Please get back to us, if you need any further assistance.

Regards,

Arulpriya

[hieudt]

Hi,

Thanks for your reply

The FilterDelay property not solving my problem. It stills slowing/delaying/hanging when I enter and leave cell which has ComboBox CellType

Regards

[Arulpriya Ramalingam]

Hi Hieudt,

Thank you for the update.

We have validated the provided sample and the reported scenario occurred due to your CustomCell renderer customization for ComboBox. In your custom renderer, you have used foreach loop in GetlistFromArray() and SetSuggestedChoices() method. In order to overcome this scenario, we would suggest that you to use linq queries to get the specified items from the data source.

Please get back to us if you need any other assistance.

Regards,

Arulpriya