JSP Performance Troubleshooting
I am running into some performance problems with my JSP application. We are using JRun as the server. My page is executing a stored procedure in SQL Server, storing the data from the resultset in an arraylist of objects that I created to store the data and displaying the data in increments of 50 in an html page. I store the arraylist as a session attribute.
In one particular example the resultset is 278 records. The stored procedure takes about a second to run using the Query Analyzer. The page takes several minutes to display.
Does anyone know where I should begin to look to improve the performance of this page? I could post the code from the page, but I didn't want to just throw that out there without a specific question about it.
Thanks for your time.
Matt
