Classic ASP Auto Suggest Like Google

Question

While working on a project i came across a functionality in which i need to implement auto suggest textbox using classic asp. I did it and it works fine. I'm using XMLHttp Request object to pick the database column values when user enter something in textbox.

Everything works fine. But if the table have too many rows (37,000+) in it, the performance of the application decreases. Please suggest what steps should i take in order to improve the performance in this case.

Answer 1

Use indexes on the database fields that you have in your where-statement in the query and it will go much faster.