Click here to Skip to main content
Sign Up to vote bad
good
See more: C#ASP.NET
Hi,
 
in my sample project the AutoCompleteExtender takes about 12 to 15 seconds to load, but only the 1st time.After the first time it takes 0.5-1 sec.

How can i solve this. If any one about this tell me.
 
Regards
Nanda Kishore.CH
Posted 11 Oct '12 - 21:29

Comments
Aman.A - 12 Oct '12 - 4:01
You are the same person asking about the "Page level cache" problem too, aren't you? :) Anyway, in this case it really depends on how much data you are loading in your auto-complete extender and whether or not the data is coming from just one table or its being joined with several other tables and then returned. And the reason it takes only 0.5-1 secs second time on, is that it caches previously loaded results and uses them if you type in the same query string again (i.e. if you set the caching property to true). Have a look at your DB queries and the query execution plan. Optimisation problems are very specific to the system architecture and overall design, so it is difficult to come up with a general remedy.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 419
1 Mahesh Bailwal 343
2 CPallini 245
3 Maciej Los 230
4 Aarti Meswania 173
0 Sergey Alexandrovich Kryukov 9,162
1 OriginalGriff 7,194
2 CPallini 3,923
3 Rohan Leuva 3,176
4 Maciej Los 2,633


Advertise | Privacy | Mobile
Web01 | 2.6.130516.1 | Last Updated 12 Oct 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid