Hi, You can show some defined set of the results per page say 10 or so and provide Prev and next Button which would fetch the next 10 rows when the user click it, now the question remains is whether to get all the data at the same time or request the data from the DB when the user clicks Previous or Next button, but this is more of design decision that you need to take..hope this helps
Regards, Mittal S.Bhiogade GE-Supply. -----Original Message----- From: Peter Dolukhanov [mailto:peter.dolukhanov@;NCL.AC.UK] Sent: Thursday, November 07, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: Re: Speeding up Resultsets Have a look at using Count(*) and Limit x,y functions in SQL to achieve the desired effect. -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:JSP-INTEREST@;JAVA.SUN.COM] On Behalf Of Steven A. Martin Sent: 07 November 2002 14:10 To: [EMAIL PROTECTED] Subject: Re: Speeding up Resultsets 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 =========================================================================== 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
