Re: Resultset

[James Mitchell]

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