Hi, You should be lucky if you saw all the 14000 records in 2.5 minutes.!! My observation is that I see the browser hung with even 1200 records approx.
The reason is that Browsers won't render the table (if you are using HTMLtable) untill it's full loaded - as Marc has pointed out. What I did in such a case was to display the result pagewise with "next", "previous" button. So, you shoud rewrite your query in such a way that it should return next/prev 'n' rows when the user pressed next/prev buttons. - Joshy -----Original Message----- From: Daniel [mailto:daniel@;MUSTANG-TECHNOLOGIES.COM] Sent: Thursday, November 07, 2002 10:08 AM 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