{"data":{"id":"ACSD-46938","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue with the performance of DB triggers recreation during setup:upgrade.","categories":["Performance"],"components":["magento/framework"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-50/acsd-46938-fix-for-db-triggers-performance-issue-during-setup-upgrade","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-50/acsd-46938-fix-for-db-triggers-performance-issue-during-setup-upgrade.md","blobSha":"3bf0c533e857e2db2379134eded84c7782877b86","description":"Performance degradation during DB trigger recreation in setup:upgrade.","stepsToReproduce":"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.","introducedInQpt":"1.1.50","createdFor":["2.4.4"],"documentedRange":"2.4.4 - 2.4.5-p9","scheduledFixRelease":null},"files":[{"package":"magento/magento2-base","constraint":">=2.4.4 <2.4.6","path":"patches/os/ACSD-46938_2.4.4.patch","blobSha":"fd71ec6f5e55ffac4aa39c5785ef8e564cb5107c","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-46938_2.4.4.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/framework/Mview/TriggerCleaner.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Mview/View.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Mview/View/Subscription.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Mview/View/SubscriptionTriggersInterface.php","change":"added","package":"magento/framework"},{"path":"vendor/magento/framework/Mview/ViewSubscriptionInterface.php","change":"added","package":"magento/framework"}],"packages":["magento/framework"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"magento-commerce":["2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"magento-commerce":["2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-46938 details"}