C# sends SQL data 4 times less from one box than from another
- by Bobb
W2003, .NET 3.5, SQL 2008
I have prod and UAT app servers deployed in 2 different data centres. I have a C# app which reads text file, parse the text and sends the data to the SQL in bulk.
SQL server is in US and the app servers are in London (but in different places). All POPs have dedicated network connections. There is no public internet…