Thanks for SHaring your views, I have a couple points :
> > 2. Bring all the data from the server into a vector on the server side
>and
> > manipulate from there.
>
>I don't think I understand this one. Do you mean to reload but not read
>from the database but from a vector (in session/application scope)?
I mean populating a vector on the server side and keeping that in
sessionContext , so I reload from the vector and not the database. Will that
be a possible solution? What are the down sides?
>2) Have an applet do it. This is the solution we have chosen. When the
>use changes the "key"- value, an applet connects to the server which
>retrieves the record from the database. Then the applet updates the
>fields and combos. You could do this using a socket connection but we
>chose to have it all JSP. So the applet connects to JSP which delivers
>the record(s) in XML format. The applet parses the XML with NanoXML
>(http://nanoxml.sourceforge.net) and updates the page. Works very neat
>for us (at least in the dev environment...)
>
>Mail me if you want more info on this or maybe try a demo page.
I am not very sure abt the performace of applets? Will that add may
overheads to the system? I would like to try the option.. Can you guide me
on this please?
> > 4. replicate the table into a XML document and parse from there each
>time.
>
>If you mean to parse this XML from (an applet on) the client side, this
>is even worse than the first alternative. Besides XML probably gives you
>more overhead (tag names) than "hidden" JavaScript, you would have to
>parse that 5000+ record XML on the client AND THEN, on the client side,
>find the data you are looking for.
I was thinking on lines of parsing the XML from the JSP... just so that I
can populate from the XML rather than the database. Will it not be faster to
parse from a formatted XML doc than the database?
thanks,
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