VCST-1752: Fix performance degradation on SQL Server - Githubissues

VirtoCommerce / vc-module-cart

Shopping cart management module

12 stars 15 forks source link

VCST-1752: Fix performance degradation on SQL Server #150

Closed artem-dudarev closed 2 months ago

artem-dudarev commented 2 months ago

Description

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
  }

References

QA-test:

Jira-link:

https://virtocommerce.atlassian.net/browse/VCST-1752

Artifact URL:

https://vc3prerelease.blob.core.windows.net/packages/VirtoCommerce.Cart_3.811.0-pr-150-d5bd.zip

sonarcloud[bot] commented 2 months ago

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud