I have large number of records to be written into a file which might exceed the length of a string param variable. So,I'm thinking of writing each record one by one rather than collecting all records in single variable and then writing it in file in one go.
To do that I need to use connect file in a loop.Is it recommended to do so? Will opening filestream again and again to write records in file using file connect create unnecessary overheads?
If not recommended, is there some other way to do this?