ACSD-62415: Adobe Commerce backend loads Categories very slowly when anchor categories are present
The ACSD-62415 patch fixes the issue where the performance of the Categories page in the Admin panel loads very slowly when a large number of anchor categories are present. This patch is available when the Quality Patches Tool (QPT) 1.1.68 is installed. The patch ID is ACSD-62415. Please note that this issue is scheduled to be fixed in Adobe Commerce 2.4.8.
Affected products and versions
The patch is created for Adobe Commerce version:
- Adobe Commerce (all deployment methods) 2.4.7-p6
Compatible with Adobe Commerce versions:
- Adobe Commerce (all deployment methods) 2.4.7 - 2.4.7-p6
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
The Categories page in the Admin panel loads very slowly when a large number of anchor categories are present.
Steps to reproduce:
- Generate 3K anchor categories.
- Open Catalog > Categories page in the Admin panel.
Expected results:
The Categories page loads quickly, and the query should not be repeated 1K times.
Actual results:
Loading takes 7 to 20 seconds, and the query is run more than 1K times.
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.