LadyReader1
Member
- Joined
- Apr 11, 2007
- Messages
- 10
- Programming Experience
- 10+
I am coding in asp.net (VS 2003) and inherited a web app. A user recently complained that the app is timing out when he clicks a particular button. The button action is to to do a very simple SQL table Insert, and then refresh the page's datagrid information to include the new data (a process that is moderately complicated, with calculated fields and data retrieved via sproc from a non-SQL db). I put a breakpoint on the button_click and found it took over 20 seconds just to get to that breakpoint (and that was before executing the SQL command or the databind).
The original programmer has the DataAdapter, SQL Connection and SQL command created at design time, in the page tray.
Can someone describe to me what's going on behind the scenes and also, in general what can be done to speed things up? What tools are available to research this problem?
The original programmer has the DataAdapter, SQL Connection and SQL command created at design time, in the page tray.
Can someone describe to me what's going on behind the scenes and also, in general what can be done to speed things up? What tools are available to research this problem?
