Along the line Marc was saying, you probably want to limit your resultset by altering your sql to make a smaller return value.
----- Original Message ----- From: "Marc te Vruchte" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 5:47 AM Subject: Re: Speeding up Resultsets > Are you displaying the result in a Table? Browsers won't render the table untill > it's full loaded, meaning until it reads </table>. You could decide to render the > results in smaller tables, 25 rows of data per table or something, or just drop the > tables completely. > > | -----Original Message----- > | From: A mailing list about Java Server Pages specification and reference > | [mailto:JSP-INTEREST@;JAVA.SUN.COM]On Behalf Of Daniel > | Sent: Thursday, November 07, 2002 05:38 > | To: [EMAIL PROTECTED] > | Subject: Speeding up Resultsets > | > | > | Hi, > | > | I have about 14,000 records and I run a simple query to display that and > | it took me half a second to see the results. > | But If I display the result on the browser it takes me about 2-2.5 mts. > | Is there a way to speed up displaying these records in my browser? > | > | Regards, > | Daniel.E > | > | =========================================================================== > | 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 > =========================================================================== 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
