> 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
