File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes It takes very long to generate a page Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "It takes very long to generate a page" Watch "It takes very long to generate a page" New topic

It takes very long to generate a page

Vikrant Ingle

Joined: Oct 27, 2006
Posts: 1
I have created a web page to display the information from the Oracle Database into a page.

Here is a list of fields i am using. figures in the () indicates the Nos.

|__ DIVISION (135)
|__ BU (600)
|__ SSTN (2000)
|__ FEEDER (9000)
|__ DTC (180000)

A CIRCLE has DIVISIONS, DIVISIONS has BU, .... and so on.

When an USER logs in at a DIVISION level can see his BUs, SSTNs and so on.
All the data is fetched for a DIVISION from the Oracle Database using the class and stored in the map are stored as session attributes.
The user can view data of a BU at a time. a drop-down is created using the JSP which expand or collapse when clicked.
Further when the user changes the BU the data is refreshed for the seleted BU from the MAPs stored as session attributes.

Now when the FEEDER Details (say, Name of Feeder) is to be modified then another window is opened which shows the details of that perticular FEEDER and can be modified. I have 2 fields in the FEEDER Screen (i.e. SOURCE BU and SOURCE SSTN) which has the list of ALL the BUs (i.e 600 Nos.) and ALL the SSTNs (i.e. 2000 Nos.) are required only if the FEEDER is to be MODIFIED or ADDED, hence MAPs of these 2 fields and some master lists (from which the data is to be selected) are created using a class and pulled in a MAP which inturn are stored as session attributes when the FEEDER Details is clicked.

But considering the VOLUME of data it takes very long to create the page.

Can anyone help?

[ July 24, 2008: Message edited by: Vikrant Ingle ]

[ July 24, 2008: Message edited by: Vikrant Ingle ]
[ July 24, 2008: Message edited by: Bear Bibeault ]
Amit Ghorpade

Joined: Jun 06, 2007
Posts: 2846

Hi Vikrant Ingle welcome to Javaranch,

If the data is too large, why dont you retrieve it in fragments or slots.
Also putting a lot of data in session will cause performance overhead.

Hope this helps

|Asking Good Questions|
I agree. Here's the link:
subject: It takes very long to generate a page
It's not a secret anymore!