20,000 or 2,000??? Please tell me you are (seriously) *not* going to do this.
I'm not even going to help you figure this out........this would be insane. I have a better idea. Why don't you create 20,000 different htm files and then link to each one. That way it would be faster!!!!! That makes about as much sense. James Mitchell Software Engineer\Struts Evangelist Struts-Atlanta, the "Open Minded Developer Network" http://struts-atlanta.open-tools.org > -----Original Message----- > From: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED]]On Behalf Of David Castro > Sent: Tuesday, June 18, 2002 12:51 PM > To: [EMAIL PROTECTED] > Subject: Re: Combo : help needed > > > > I have a jsp page on which I want to populate a HTML combo box > from items > > tables. Issue is that, item table has as many as 20000 records, I put a > > query to select all records and populate on combo, then nothing > comes and it > > times out. How to handle this situation ? > > So, let me get this straight. You want to create a combo box with > as many as > 20,000 items in it? And you actually have a use for something like this? I > can't imagine someone being willing to scroll through 19,421 > items to get to > item #19,422. Can you maybe segment them, and have users drill down to > individual items? (Kinda like the categories on Ebay...start at "Arts & > Crafts", then choose "Scrapbooking", then choose "Paper Piecing", > and so on.) > > If you cannot do this, and if your server has all sorts of unused > RAM, and if > these values don't change often, maybe you could create a Vector in the > Application scope. You could set it up to generate the Vector as often as > needed. And then outputting those values on your page won't time out. But > 20,000 items is gonna take up a lot of memory! > > -David Castro > email[at]davidcastro[dot]com > http://jsp.davidcastro.com > > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.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://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
