Speeding up jsp  
Author Message
Michael G.





PostPosted: 2004-8-4 6:34:00 Top

java-programmer, Speeding up jsp
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 8.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.

Mike


 
robC





PostPosted: 2004-8-6 0:23:00 Top

java-programmer >> Speeding up jsp Put your query in query analyzer, find out if it is the DB, or the
network. If it's the DB, try creating indexs to speed it up, if it's
the network, reduce your result-set size, try pulling back just the top
x rows instead of the whole thing. If you need all the rows, and you
are being limited by network bandwith, you are SOL :-)