Hello, I'd like to know about ways to speed up a java application. We're using jsp java beans on a webserver running Apache/Tomcat 4.1.18. It's accessing database information through ODBC from a Microsoft SQL Server version 7.0 database across a network. We're encountering some problems with one jsp page because I think it's retrieving a large result set from the database. The query in question selects from a database with over 30000 records. We're using JDBC, and limiting our select to only one database column. Any recommendations about speeding up the specific problem with this jsp page, or any general suggestions on performance improvements would be welcome.

When I have performance issues with Java/SQL, it usually has to do with the query itself taking a long time to run. The first thing I would look into would be optimizing the query, if you haven't done so already, or take a look at the database tables. There are many ways to make data access faster if that is what is slowing your stuff down. You can even try denormalizing your tables and making them into faster lookup tables, etc. Also, with the jsp page, check to see what you are doing with the data and make that more efficient. Check out any loops and processing and see if there are more efficient ways of coding it. P.