7000 Values in a combo box is definitely not the answer, you have to
rethink your user interface.
Maybe have a option to search for the value with wildcards ? (lookup type
function).
Combo boxes are useful for small numbers of values ( sex , age category
etc.).
Remember the values in the combo box are dragged over to the client as
part of the html page , in your case you will send the whole table over to
each client every time , no wonder it takes 7 minutes.
Hein van der Merwe
On Thu, 3 Aug 2000, Dinesh Venkatraman wrote:
> Hi all,
>
> I have a servlet which populates the database values into a combobox in
> the browser page.
>
> There are more than 7000 records in the database.
>
> When I try to insert all of them into the combobox, which takes more
> than 6 to 7 minutes, the bowser gives the message that connection has been
> timed out.
>
> Guide me with a solution.
>
> thanks in advance.
>
> G.V.Dinesh.
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> 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
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
