General Advice : Jsp & Database

I am building a jsp site that will be making some heavy data base demands
and I would like to get opinions about the best stratedgies for setting up
the logic of it all.

I will be using the latest iPlanet (NT for for devlopment Unix for deployment), Java 2, oracle and my own home made beans.

I have been given a set of stored procedures used to get back individual pieces of data that I need.

Depending on options ( check boxes ) that the user picks, each single piece of data retrieved will necessitate another data base call to get "sub data" related to that piece of data.

My inclination is to collect all of these pieces in the bean, do the HTML
formatting on each piece, concatanate it all into one big fat string and output to the website in one piece.

Will this slow down my web server ( iPlanet )? Will it tax the resources
of my web server more then if I sent each piece of data to the web site as
I retrieved it instead of collecting it all first?

I plan on executing each "sub query" as each piece of data is retrieved. Is there anything else I can do to speed up retrieval from the database?

Any suggestions would be greatly valued

Steve

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 25 2000 - 22:25:15 CEST