Multiple Active Result Sets

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
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
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
Vote:
 

Thank you both for your answers!

/Daniel

#293210
Dec 15, 2022 20:25
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.