Re: JSP/Servlet performance related question

From:

Eric Sosman <esosman@acm-dot-org.invalid>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 15 Dec 2006 18:05:36 -0500

Message-ID:

<weGdnVGNKpPbtx7YnZ2dnUVZ_silnZ2d@comcast.com>

itreflects@gmail.com wrote:

Hello,
I have JSP performance related concern.

Here is the situation: My Database table has 10,000 records, I fetch
these records in a servlet and do all the necessary calculation on each
record and come up with a set of say 10 parameters for each record. All
these 10 parameters per record are displayed in a JSP and 10,000 are
iterated in JSP and shown in HTML table.
In servlet class I am storing all 10 parameters in a Vector object and
adding this Vector object to an ArrayList object. This ArrayList object
I am putting in session (HttpSession) to make it available to JSP page.
All is well, page works fine.Concern is that it takes around 3 minutes
to load onto browser.
My questions are:

How can time to load the JSP page be reduced?
Is storing such a large ArrayList object in session a good practice?
what are the alternatives to make huge data available to JSP?

Any comments are welcome.

The first step I'd suggest is to locate the bottleneck.
You seem to be concentrating on the server, but it's not out
of the question that a browser might take quite a while to
render a table of 100,000 cells. A simple test would be to
save the generated HTML to the browser's local disk, shut
down and restart the browser (to dodge cache effects), and
then time how long it takes to do an "Open File..." on the
saved page. If it's three minutes, you need to think about
writing better HTML (or making a smaller table). If it's
three seconds, then you might start looking at the network
speed and at the server.

But first things first: Build the wolf fence.

--
Eric Sosman
esosman@acm-dot-org.invalid