Hi,
I have a situation I would like to discuss in the group. Let me illustrate
using this problem statement.
We are building a web based application and are using JSP on weblogic on
Solaris with Oracle 8I as the database.
At least 80% of the screens , need to show a set of selection boxes ( combos
) , which also filter dynamically on selection.
For example, consider the combos to be Country State City PinCode Lname
Fname
First , country combo lists all the possible countries.
On selection of a country, all valid states are populated in the state
combo.
On selection of a State, all valid cities are populated in the state combo
and so on�.
In the real scenario, I have approximately : 7-8 combos which will be put up
for user selection.
The data all comes from One table , which will have approx 5000 rows of data
for now , and will grow with time.
I considered the following options :
1. Bring all the data to the client side and store them in hidden combos or
put them in a javascript array and manipulate the same.
2. Bring all the data from the server into a vector on the server side and
manipulate from there.
3. Hit the database on the change event of each combo ( I don�t like the
thought of this )
4. replicate the table into a XML document and parse from there each time.
We also need to consider that this functionality is on majority of the
screens and the response time/ performance is very crutial.
Hoping to get ur views / suggestions,
Thanks in advance,
Vini
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
