Have try to use the setFetchSize method Also have alook at ELIMINATE JDBC OVERHEAD
A reusable, flexible SQL architecture tackles JDBC programming inefficiencies http://click.idg.email-publisher.com/maaansAaaSio2a9JSc6b/ Regards Rinaldo -----Messaggio originale----- Da: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]] Per conto di Andrea Inviato: marted� 28 maggio 2002 14.21 A: [EMAIL PROTECTED] Oggetto: Re: Resultset the time increases for each record ( until 16000 it tooks around 4 seconds ) ----- Original Message ----- From: "PEARCE Robert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 2:15 PM Subject: Re: Resultset Is it 300ms for each record after 8000 or for just one? The implementation of ResultSet may be fetching a new batch of data from the database -----Original Message----- From: Andrea [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:12 To: [EMAIL PROTECTED] Subject: Resultset Hi all I have some problems with the object resultset I make a query that has 16000 records and when I use the rs.next() for the first 3000 records I have an elaboration time about 30 msecond but about the 8000� record i have an elaboration time of 300 mseconds (for single record ). I need to low this time how can I do? ( in the while(rs.next()) i wrote only a line in the log) There is an object more efficent than resultset? Or can you suggest me a way to write my code? thanks Andrea This e-mail is confidential and intended only for the addressee(s) shown. If you are not an intended recipient, please be advised that any use, dissemination, forwarding or copying of this e-mail is strictly prohibited. Internet e-mails are not necessarily secure and the AXA Group does not accept responsibility for changes made to this message after it was sent. Please note that incoming and outgoing electronic mail messages may be monitored. Should you receive this transmission in error, notify the sender immediately. Thank you ________________________________________________________________________ ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ________________________________________________________________________ ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
