{"data":{"id":"ACSD-67102","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue when Adobe Commerce backend loads categories very slowly.","categories":["Admin","Performance"],"components":["magento/module-catalog"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-70/acsd-67102","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-70/acsd-67102.md","blobSha":"e22141e3aeb70c67c8ce6f794c8e8078fb899350","description":"Category loading is slow or times out when a large number of categories and products are involved.","stepsToReproduce":"1. Create a new clean instance. 1. Create categories and products: 1. Copy setup/performance-toolkit to ./var to make profiles editable. 1. Edit small.xml profile and set categories to 2500 and products to 250000. 1. Run bin/magento setup:performance:generate-fixtures var/setup/performance-toolkit/profiles/ce/small.xml 1. Verify all categories are set as anchors by running the following query: UPDATE catalog_category_entity_int set value = 1 where attribute_id = (select attribute_id from eav_attribute where attribute_code = 'is_anchor'); 1. Go to the Admin menu. 1. Confirm a deeper category structure exists. 1. Move Category 2 deeper into the Category 1 tree to reflect the intended hierarchy. 1. Reindex.","introducedInQpt":"1.1.70","createdFor":["2.4.7-p4"],"documentedRange":"2.4.7 - 2.4.7-p7","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.7 <2.4.8","path":"patches/os/ACSD-67102_2.4.7-p4.patch","blobSha":"6c97c20885cbaf4665dc7a3154c282c9f2d24955","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-67102_2.4.7-p4.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog/Model/ResourceModel/Category/Collection.php","change":"modified","package":"magento/module-catalog"}],"packages":["magento/module-catalog"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":"ACSD-68064","deprecated":false}],"applicableVersions":{"magento-community":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-67102 details"}