Some databases have the option of viewing statistics or a query plan for a query. This might tell you what is going on. Does it behave the same way when the query is run direct on the database (i.e. through some sort of SQL client)?
-----Original Message----- From: Andrea [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 14:00 To: [EMAIL PROTECTED] Subject: Re: Resultset yes for the first question Oracle for the second ----- Original Message ----- From: James <mailto:[EMAIL PROTECTED]> Mitchell To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 2:57 PM Subject: Re: Resultset Is this part of a "download as csv" from your web page? What DB are you using? James Mitchell -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Andrea Sent: Tuesday, May 28, 2002 8:52 AM To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Subject: Re: Resultset I have to write a .csv file with those records so I must read them then write them.... I know that is a bad way but is the only one according to the requirements If you know a better way please tell me ----- Original Message ----- From: James <mailto:[EMAIL PROTECTED]> Mitchell To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 2:44 PM Subject: Re: Resultset Why would you ever want to iterate over 16,000 records in a SERVLET??????? What part of any application could possibly have such a requirement? You're better off having the database write out to a text file then to use a servlet do it. Could you explain why you need this so we can have a better understanding of "where you're coming from"? James Mitchell -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Andrea Sent: Tuesday, May 28, 2002 8:12 AM 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
