I find that if WriteLine writes to a local server folder performance is ok, ~50 meg in under 50 seconds.
However, if WriteLine writes to a file on a different server performance crawls. I can watch the file grow a few k at a time until the whole file takes 90 to 100 minutes to complete. The file has ~50,000 rows and each row is a separate writeLine.
Our network engineers have checked and said...There are no issues on the servers, no firewall problems, hardware problems, network latency, bandwidth or anything else they can think of to check and test.
As a work around, we can write the file local to the server and then copy the file to the network share; however, this requires two writes to the file (and double the disk space).
I have checked the internet and do not find anyone else having this problem.
Has anyone had this problem or know of another way to write to a file other than writeline to fix this problem?
-bob