I have two auto completes working on the main page of this application. One on the header and one that appears when the user resizes the browser down to a smaller screen width/
Both use the same controller ajax action. It seems the first time the user types in the values it take about 5 seconds to render matches. And subsequent searches are instant.
Is there a way to optimize that so that that first search is instant? Please note that the dataset is large. Over 10,000 products. But that data is cached in .NET Core at application startup so it is not hitting the database again on each search or a web service, rather reading from the same cached list. And that list is optimized to contain only two fields, the product name and primary key.
Is there a way to pre-read the data for the list to make it faster?
Thanks
6 Answers, 1 is accepted
You could take a look at the following online demo with Virtualization and ServerFiltering for the AutoComplete, which is suitable for large data sets:
Hope this helps.
Regards,
Konstantin Dikov
Progress Telerik
Rank 2
Hi Konstantin,
I was not able to get this working with that link. Where does the ValueMapper JavaScript URL come from? In the demo it is not declared in the controller.
Rank 1
You are correct that the ValueMapper code is not present in the demo. The code could be found in our public repository with the services used in our online demos:
Nevertheless, as documented in the following help topic, the "valueMapper" is not needed from version R3 2016:
Regards,
Konstantin Dikov
Progress Telerik
Rank 1
Thanks for the reply. But, that still doesn't help. I could only get auto complete working with server filtering, which works fine, and I'm assuming with a relatively small data set being returned (< 100 records), that virtualization may not be needed? But, according to the docs, you need a pagesize for virtualization, but couldn't set that in the data source config, or anywhere else in the config:
.DataSource(source =>
{
source.Read(read =>
{
read.Action("GetUsers", "Admin")
.Data("onAdditionalData");
})
.ServerFiltering(true);
})
Plus, as per my previous posts, there's no where to insert the request verification token, to pass back to the controller as it is posting data. It's better to just post a complete working example of virtualization, as there's no need for us to spend time on minor details like setting up value mapper, and finding out how to pass back a token.
The PageSize could be set to a Custom DataSource, as demonstrated in our online demo:
As for a working example, you could test this in our offline demos shipped with the product:
On a side note, for all sides convenience, please try to avoid using multiple threads with the same question. Thank you for your understanding.
Regards,
Konstantin Dikov
Progress Telerik