# \#performance

**URL:** https://www.virtocommerce.org/tag/performance/7.md

[Latest](https://www.virtocommerce.org/latest.md) · [Categories](https://www.virtocommerce.org/categories.md) · [Tags](https://www.virtocommerce.org/tags.md)

---

## [Performance Degradation in MS SQL Database Queries After Upgrading to EF Core 8: OPENJSON - Contains](https://www.virtocommerce.org/t/performance-degradation-in-ms-sql-database-queries-after-upgrading-to-ef-core-8-openjson-contains/731)

<div class="topic-metadata">

**Author:** [@OlegoO](https://www.virtocommerce.org/u/OlegoO)\
**Replies:** 0\
**Last updated:** [September 5, 2024, 3:44pm UTC](https://www.virtocommerce.org/t/performance-degradation-in-ms-sql-database-queries-after-upgrading-to-ef-core-8-openjson-contains/731 "2024-09-05T15:44:06Z")

</div>

Hello Virto Commerce Community, After upgrading to EF Core 8 (EFC8), we’ve encountered several severe performance regressions where previously millisecond queries started timing out. This issue is particularly evident i…

---

## [Optimizing Performance: entityframework-extensions.net with Virto Commerce Platform](https://www.virtocommerce.org/t/optimizing-performance-entityframework-extensions-net-with-virto-commerce-platform/610)

<div class="topic-metadata">

**Author:** [@OlegoO](https://www.virtocommerce.org/u/OlegoO)\
**Replies:** 4\
**Last updated:** [August 6, 2023, 8:14am UTC](https://www.virtocommerce.org/t/optimizing-performance-entityframework-extensions-net-with-virto-commerce-platform/610 "2023-08-06T08:14:26Z")

</div>

In this post, I want to describe how to turbocharge Virto Commerce performance and efficiency! With the integration of the entityframework-extensions.net library, we have unlocked a powerful feature that will significant…

---

## [Maintenance Task for Hangfire](https://www.virtocommerce.org/t/maintenance-task-for-hangfire/307)

<div class="topic-metadata">

**Author:** [@OlegoO](https://www.virtocommerce.org/u/OlegoO)\
**Replies:** 2\
**Last updated:** [April 18, 2023, 6:37am UTC](https://www.virtocommerce.org/t/maintenance-task-for-hangfire/307 "2023-04-18T06:37:36Z")

</div>

Virto Commerce uses Hangfire for Background jobs and Async workers. Every C# code can be executed in Fire-and-forget jobs only once and almost immediately after creation: var jobId = BackgroundJob.Enqueue( () =\> Co…

---

## [How to speed up showing product on storefront, when it has many variations](https://www.virtocommerce.org/t/how-to-speed-up-showing-product-on-storefront-when-it-has-many-variations/53)

<div class="topic-metadata">

**Author:** [@eMazeika](https://www.virtocommerce.org/u/eMazeika)\
**Replies:** 0\
**Last updated:** [October 17, 2019, 6:29am UTC](https://www.virtocommerce.org/t/how-to-speed-up-showing-product-on-storefront-when-it-has-many-variations/53 "2019-10-17T06:29:16Z")

</div>

Product page on Storefront might be loading too slowly because of all the bulky data that is has. Only the required information in each particular situation should be loaded. Increasing the performance for product with …