I have inherited an application which performs approximately 100,000 executions in a C# for-loop against SQL Server.for (int i=0; i<100000; i++){  //Execution can take 0.250 to 5 seconds to complete.  ExecuteProc(i); // no result returned}To reduce the time it takes to execute all 100,000 procedures, would it be better to:convert this loop to a .Net parallel-foreachloop or execute the procedure asynchronously ?
Excute Procedure in Parallel or Async
.net;performance;sql server;parallel programming;asynchronous