Skip to main content

Speeding up jsp

1 reply [Last post]
mogilby
Offline
Joined: 2004-08-04

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

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
dhall
Offline
Joined: 2006-02-17

Since you ask this on the java desktop forum, I'd recommend that you write a desktop client application that can host far more intelligent client-side querying and caching behaviour. You should be able to reduce your dependence on the server providing you new views of the data everytime you click your mouse on something. ;)

You might also find answers more closely tied to JSP performance and design on a J2EE forum.