AutoCompleteExtender taking too much time[around 10secs] to get a records from sql even though query is not complex by any means is der any alternative to get it fast
many thanks..
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
1. If the records returned are greater in number , reduce that to less number by using the TOP clause in SQL. Or let the user enter more characters. 2. Cache your data and hit the cache to return the records. 3. Create a List which will reduce the number of records before passing that to the UI/Service. 4. Improve Query Performance at the database level.
Suthish NairPosted Oct 27, 2011, 1:52 PM
Did you tried the Query Execution Plan?
Javeed M ShaikhPosted Oct 27, 2011, 12:04 PM
try to look into the following items:
1. If the records returned are greater in number , reduce that to less number by using the TOP clause in SQL. Or let the user enter more characters.
2. Cache your data and hit the cache to return the records.
3. Create a List which will reduce the number of records before passing that to the UI/Service.
4. Improve Query Performance at the database level.