Many DBMS support syntax for SELECT clause which allows to export output data in many formats (including CSV).
Andrea wrote: > 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 Mitchell > To: [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 > ___________________________________________________________________________ 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
