Multiple Active Result Sets

Daniel

Vote:

Hi,

I receive the following warning during the initialization phase:

"Database connection is configured to allow MultipleActiveResultSets. Consider disable MultipleActiveResultSets for better performance." (SourceContext: EPiServer.Data.DataInitialization)

According to a forum thread from 2017 MARS is a requirement. Is this still the case for Optimizely 12?

Best regards

Daniel

#293205

Dec 15, 2022 10:53

Mark Stott

Vote:

Hello Daniel,

I found this on the Optimizely Support site about MARS being disabled on Linux on DXP: https://support.optimizely.com/hc/en-us/articles/5829401650829-MultipleActiveResultSets-MARS-in-CMS-12-on-DXP

Testing on my windows development machine doesn't seem to raise issues if I have MARS set or not

#293206

Dec 15, 2022 11:10

Quan Mai

Vote:

no, MARS is no longer required for CMS 12. We actively try to disable it because it can cause severe performance issue on Linux. You can run without MARS on CMS 12

#293209

Dec 15, 2022 14:35

Ted - Dec 16, 2022 12:04

Hi Quan! I think the CMS 12 templates (for dotnet new) still append MARS to the connection string?

Quan Mai - Dec 16, 2022 12:09

I'm not aware of that, let me check and get back to you

Quan Mai - Dec 17, 2022 9:33

When you wrote dotnet new, which tool/package did you mean?

Ted - Dec 19, 2022 12:33

That was sloppy, I meant: dotnet-episerver create-cms-database

I'm fairly certain it applies to the latest version, but I'm unable to verify right now.

Quan Mai - Dec 19, 2022 12:52

Could confirm it was removed since Mars 2022

Daniel

Vote:

Thank you both for your answers!

/Daniel

#293210

Dec 15, 2022 20:25