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.
CIRCLE (40) |__ 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 ]