It seems to be an internal memory problem or maybe a problem with the logger
Do you save any data from the rs in some kind of structur or what do you do with the rs? /tonnie Andrea wrote: > 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
