Re: Resultset

[Balasubramaniyan K]

Hi       All the Database servers has the provision of writing a TABLE content to a flat file. Normally they are called as Bulk Commands.      You have to just initiate the bulk command utility.     For SQL Server it is called bcp utility.          Hope this helps.         Thanks & Regards Balasubramaniyan Krithivasan   -----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 1:52 PM To: [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 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