Performance issue in Autocomplete

[JayaPrasad KV]

I am using AutoComplete to search Addresses. Address count is more the 10K. It is causing the performance issue. 

Is there any solution to autosearch directly from a data source(Database) instead of search in local?

Thank you

[Ponmani Murugaiyan]

Hi JayaPrasad, 

Thanks for contacting Syncfusion support. 

We have provided virtual scrolling support for AutoComplete component from the version 18.3.35. To enable virtual scrolling, EnableVirtualization property to be set as true. While type any character initially matched 10 items will be shown in the popup as provided in the Take of Query property. When scrolling the remaining items will be updated in the popup dynamically. We suggest you to apply the below suggestion to get rid of the performance issue when loading large data. 

<SfAutoComplete TValue="string" TItem="OrderDetails" Placeholder="Select a name" Query="@Query" EnableVirtualization="true"> 

    <SfDataManager Url=https://ej2services.syncfusion.com/production/web-services/api/Orders Adaptor="Syncfusion.Blazor.Adaptors.WebApiAdaptor" CrossDomain=true></SfDataManager> 

    <AutoCompleteFieldSettings Value="CustomerID"></AutoCompleteFieldSettings> 

</SfAutoComplete> 

 

@code { 

    public Query Query = new Query().Select(new List<string> { "CustomerID" }).Take(10).RequiresCount(); 

    } 

} 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/AutoComplete_virtualization-1810803120 

Regards, 

Ponmani M