Auto complete Textbox binding very slowly...?

Posted by Nandkishorre under ASP.NET on 10/11/2012 | Points: 10 | Views : 1892 | Status : [Member] | Replies : 1
in my sample project i am ajax autocomplete extender for autocomplete textbox. I am binding the EmployeeName from database in autocomplete textbox. I have lakhs of records in my table(emploee table).It takes nearly 10 secs for binding in textbox data every time. how can i reduce the time for data binding in textbox.
If any one know about this Reply me.

Nanda Kishore.CH .


Posted by: Vasanthmvp on: 10/11/2012 [Member] Starter | Points: 25

Hi, i think once after user enters first 2 to 3 character..
you should have filtered your records with LIKE('_%') query then bind the filtered names to your auto complete text box.


Awesome Coding !! :)

Nandkishorre, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response