help with common ASP speed issues

[kaht]

Can anybody inform me of common asp bottlenecks or problems that would slow down a page? My project is starting to time out due to long processes. If anybody knows any common ways to speed up ASP server and the way it communicates with SQL server, please inform me. I have ran multiple SQL server traces on the back end that were captured by accessing the database thru the front end.

thanks

-kaht

[A1ien51]

Common problems could be that the SQL query is that use used * when you do not need all of the columns.

Esp. if you use count(*), just pick a column since it does not load a whole row --> count(t.people)

Joins/unions can cause problems with speed

Make sure you close connections too.

Speed basically depends on the format of your statement. I persoannly would look at each query on a page and see which one is causing the headache. Request.Write is your friend for this process.

Eric

[kaht]

thanks for the tips

-kaht