Thanks but my problem is after the query when i read the result .... the query tooks something like 2 seconds...
----- Original Message ----- From: "PEARCE Robert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 2:59 PM Subject: Re: Resultset Is the table(s) indexed? I'm not sure how indexing would cause the time taken per row to increase, but it is a thought. It sounds like either a steadily increasing set of records is being copied each time, or changed in some way (e.g. sorted?) -----Original Message----- From: Andrea [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 13:21 To: [EMAIL PROTECTED] Subject: 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 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
