3.832.3
·
20 commits
to support/3.832
since this release
🎯 Development
- Fix performance degradation on SQL Server (#2834)
Addressed performance degradation in MS SQL Server when using OPENJSON and CONTAINS. The issue was resolved by setting the CompatibilityLevel to 120 (SQL Server 2014). For more information, see this link: https://www.virtocommerce.org/t/performance-degradation-in-ms-sql-database-queries-after-upgrading-to-ef-core-8/731.
The compatibility level can be configured in the appsettings.json:
"SqlServer": {
"CompatibilityLevel": 120
}