search

VirtoCommerce / vc-module-customer

Contacts management module
Other
14 stars 22 forks source link

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

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.Customer_3.814.0-pr-251-a985.zip

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