|
#1 way to improve responsiveness: Use extensive data caching within your ASP.NET app to reduce round-trips to the database.
#2 way to improve responsiveness: Combine data requests to reduce round-trips to the database.
#3 way to improve responsiveness: Study your sql queries and do whatever it takes to optimize them, especially those that are frequently executed. Focus on reducing query complexity (i.e. O[N] rather than O[N^2], etc) whenever possible.
#4 way to improve responsiveness: Do not use Repeater or any other data-binding control. For some reason, data-binding is much much slower than a simple for or foreach loop.
#5 way to improve responsiveness: Turn on tracing, add tracing statements to your code, identify your bottlenecks, and focus on those areas specifically.
|