ACSD-46938: Performance degradation during DB trigger recreation in setup:upgrade

Categories

Performance

Components

magento/framework

Origin

adobe-commerce-support

Since QPT

1.1.50

Issue

Performance degradation during DB trigger recreation in setup:upgrade.

Steps to reproduce

1. Create a large catalog with many products and categories. 1. Log in to the Admin. 1. Set all indexers to Update By Schedule mode. 1. Open any product. 1. Update it. For example, assign a new category to it. 1. Click Save. 1. Run bin/magento setup:upgrade and bin/magento cron:run commands in parallel.

Adobe's page lists 2.4.4 - 2.4.5-p9 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-46938. On Cloud, add ACSD-46938 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-46938/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-46938
• JSON API: /api/v1/patches/ACSD-46938