none
Any performance hit with MultipleActiveResultSets=True? RRS feed

  • Question

  • Does anyone know if using MultipleActiveResultSets=True when you don't need to be will cause a performance hit?

     

    I am not sure if I should have two connection strings and only use the multiple connection string when I need to or if it is OK to just have one with MultipleActiveResultSets=True and use it for everything.

    • Edited by Chomsky Monday, May 24, 2010 7:18 PM mistyped
    Monday, May 24, 2010 7:18 PM

Answers

  • Yes, it is documented as having "additional overhead", but so does the alternative of having multiple connections / transactions.

    A quick search of the 'net didn't reveal any major performance complaints.  You'll probably be okay.

    Per: http://msdn.microsoft.com/en-us/library/h32h3abf(VS.80).aspx

    [quote]

    When a connection is opened with MARS enabled, a logical session is created, which adds additional overhead.

    [/quote]

     

    • Marked as answer by Chomsky Tuesday, May 25, 2010 1:49 PM
    Tuesday, May 25, 2010 12:13 AM