Have you tested with Millions of data from database

Mar 17, 2015 at 11:37 AM
Hi,
My requirement is to load & search millions of data for the AutoComplete TextBox. Have you tested with huge number of data from database? If so can u send me a sample.

Thanks
Selva
Coordinator
Mar 17, 2015 at 12:56 PM
Hi Selva,

If you want to search over millions of records in your database, you may query your database to return N number of matched records every time GetSuggestions method is called in the provider. If your procedure (used for searching) is properly written and optimized it must be able to return top N matched records within a second (where N <= 100).

When you are providing auto suggest functionality, user don't prefer to scroll and navigate to exact record instead he/she will prefer to refine the search text.

I had used it in one of our application where we use to search Client records over millions of records and it worked perfectly fine.


Cheers!
Deepak
Marked as answer by deepdotnet on 3/18/2015 at 10:39 PM
Mar 17, 2015 at 1:07 PM
Thanks a lot Deepak..