ACSD-65684: Upgrading Magento_Company in B2B 1.5.2 is slow with over 100,000 records in company_structure
The ACSD-65684 patch fixes a 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. This patch is available when the Quality Patches Tool (QPT) 1.1.64 is installed. The patch ID is ACSD-65684. Please note that this issue is scheduled to be fixed in Adobe Commerce 2.4.9.
Affected products and versions
The patch is created for Adobe Commerce version:
- Adobe Commerce B2B (all deployment methods) 1.5.2
Compatible with Adobe Commerce versions:
- Adobe Commerce B2B (all deployment methods) 1.5.2
magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.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:
- Install Adobe Commerce 2.4.7-p4 with B2B.
- Add 100,000 records to
company_structuretable. - Upgrade to Adobe Commerce 2.4.7-p5 and the latest B2B module (1.5.2).
- Apply patch ACSD-65540.
- Run:
bin/magento setup:upgrade
Expected results:
setup:upgrade completes in a reasonable time.
Actual results:
setup:upgrade takes an excessively long time to complete.
Apply the patch
To apply individual patches, use the following links depending on your deployment method:
- Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
- Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.
Related reading
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool: A self-service tool for quality patches in the Tools guide.