While i have been working with application perfomance tuning part i found an article for doing the same from Microsoft. it suggests me to reduce the round trip between application and database by using Sqlbatch statements. i got two ways to achieve it
1. SqlDataReader.NextResult() - we can use single connection to execute sql batch statements
2. MARS (Multiple Active Result Sets) - we can use single connection to open multiple readers and execute the batch statements
MARS is having both advantages and disadvantages like Multiplexing and Thread Safety (no).
i like to know the difference between both of them , why do we need MARS instead of SQLReader.NextResult() while it solves our batch execution using a single connection?
View Complete Post