{"data":{"id":"ACSD-65684","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the performance issue where upgrading the Magento_Company module after updating to B2B 1.5.2 took an excessively long time when processing a large number of records (~100,000+) in the company_structure table.","categories":["B2B","Performance"],"components":["magento/module-company"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-64/acsd-65684-performance-issue-where-upgrading-the-magento-company-module-after-updating-to-b2b-1-5-2-took-an-excessively-long-time-when-processing-a-large-number-of-records-100-000","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-64/acsd-65684-performance-issue-where-upgrading-the-magento-company-module-after-updating-to-b2b-1-5-2-took-an-excessively-long-time-when-processing-a-large-number-of-records-100-000.md","blobSha":"8b73b2c5ba3f42f4e37e28e32e1cadd0ddba0f58","description":"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.","stepsToReproduce":"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","introducedInQpt":"1.1.64","createdFor":["1.5.2"],"documentedRange":"1.5.2","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-b2b-base","constraint":"1.5.2","path":"patches/commerce/ACSD-65684_B2B_1.5.2.patch","blobSha":"1f9b0aa40f6b5e1309305be5412467a2ee519280","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-65684_B2B_1.5.2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-company/Setup/Patch/Data/SetCompanyForStructure.php","change":"modified","package":"magento/module-company"},{"path":"vendor/magento/module-company/etc/db_schema.xml","change":"modified","package":"magento/module-company"},{"path":"vendor/magento/module-company/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-company"}],"packages":["magento/module-company"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.8","2.4.7-p5","2.4.6-p10"],"mage-os":[]},"unknownVersions":[],"requires":["ACSD-65540"],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.8","2.4.7-p5","2.4.6-p10"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-65684 details"}