AnushaN1 Member since 2016 2 posts
Posted: 1 year ago
Last activity: 1 year 7 months ago

How to configure Auto Complete for huge amount of data

We have a requirement to configure Auto Complete that needs to query on a table with 100k records.

As the Auto Complete control reads all the data onto the clipboard and then filters the results based on the characters entered by the user, giving the maximum number of rows to retrieve in a Report Definition doesn't help. It slows down the system and there is so much of delay in getting back the data.

Indexes have already been created in the table for the columns that are being used in the Auto-Complete for search and display.

Can Auto-Complete control be used against a table with huge amount of data like 100k and it would grow in future.Please post some suggestions to handle this scenario.

User Interface
Moderation Team has archived post
Share this page LinkedIn