Since this is a web application, you are likely to be doing a lot of similar queries. If you haven't already done so, switch your Statements to PreparedStatements. The database only has to compile them once, which saves a lot of time.
Another big thing is to check the execution plan in the database. This will make sure that indexes are being used. Also, check you aren't doing a "select *" and returning unneeded columns.
For all of these, you need to do some analysis and see which queries are taking the longest so you can focus on those. You can also post that query here for suggestions.
Joined: Jun 10, 2004
Thanks Jeanne. I will investigate in datail and get back to the forum....