Is there a way i can write to CSV Faster?

Asked May 18 '20 at 22:03

Active May 18 '20 at 22:03

Viewed 38 times

I have a for Loop that grabs data from a data table and writes to a text file, as csv. This works great for small csv files but becomes very very slow when writing bigger csv files, say 5000 records takes 2 minutes. Is there a better way I can do this?

Thanks.

Dim dt As New DataTable()
 dataadapter.Fill(dt)

For i As Integer = 0 To dt.Rows.Count - 2

                For j As Integer = 0 To dt.Columns.Count - 1
                    writer.Write(dt.Rows(i).Item(j).ToString().Trim() & ",")

                Next

            Next

asked May 18 '20 at 22:03

Krushan

Maybe write to the file once instead of for every row and column? Here's [a similar question](https://stackoverflow.com/a/4959869/5162073). – Brian M Stafford May 18 '20 at 22:22
Are you sure that writing to ta file is a bottle neck of the problem? – Fabio May 19 '20 at 01:47
No. But if all else fails you can give it a try. – Brian M Stafford May 19 '20 at 13:40
You don't show how you obtain the writer - so I am guessing it's a file writer? If so, consider writing to an in-memory stream, then flushing that to a file stream outside of the loop – Stewart Ritchie May 19 '20 at 15:44

Is there a way i can write to CSV Faster?

0 Answers0