ACSD-65684: Performance issue where upgrading the Magento_Company module in B2B 1.5.2 takes too long…
Performance issue where upgrading the Magento_Company module in B2B 1.5.2 takes too long when processing 100,000+ records in the company_structure table. Quality patch ACSD-65684 for magento/module-company applies to Magento Open Source and Adobe Commerce 2.4.6-p10 to 2.4.8.
- Categories
- B2B, Performance
- Components
- magento/module-company
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.64
Issue
Performance issue where upgrading the Magento_Company module in B2B 1.5.2 takes too long when processing 100,000+ records in the company_structure table.
Steps to reproduce
1. Install Adobe Commerce 2.4.7-p4 with B2B. 1. Add 100,000 records to company_structure table. 1. Upgrade to Adobe Commerce 2.4.7-p5 and the latest B2B module (1.5.2). 1. Apply patch ACSD-65540. 1. Run: bin/magento setup:upgrade
Adobe's page lists 1.5.2 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.
Adobe scheduled the permanent fix for 2.4.9.
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-65684. On Cloud, add ACSD-65684 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-65684/ 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
magento/magento2-b2b-base 1.5.2
- Magento Open Source
- —
- Requires
- ACSD-65540
- vendor/magento/module-company/Setup/Patch/Data/SetCompanyForStructure.php
- vendor/magento/module-company/etc/db_schema.xml
- vendor/magento/module-company/etc/db_schema_whitelist.json
