search

VirtoCommerce / vc-platform

Virto Commerce B2B Innovation Platform
https://virtocommerce.com
Other
1.23k stars 845 forks source link

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

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:

Image tag: ghcr.io/VirtoCommerce/platform:3.851.0-pr-2834-5cf0-vcst-1752-5cf0c137

sonarcloud[bot] commented 2 months ago

Quality Gate Passed 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