ACSD-65848: The Admin category view/edit page experiences significant delays when loading

Categories

Performance, Catalog/Product

Components

magento/module-catalog

Origin

adobe-commerce-support

Since QPT

1.1.66

Issue

The Admin category view/edit page experiences significant delays when loading. The delay is caused by the method used to calculate the total product count in a category, which relies on a sub-select query. Refactoring this logic to use a join instead improves performance and reduces load time.

Steps to reproduce

1. Create a new Adobe Commerce Cloud instance using version 2.4.8. 1. Create 2,500 categories and at least 10,000 products: 1. Copy the setup/performance-toolkit directory to ./var so you can edit the profiles. 1. Open the small.xml profile and update it to include 2,500 categories and 250,000 products (to match the merchant's setup). 1. Run the following command to generate the fixtures: bin/magento setup:performance:generate-fixtures var/setup/performance-toolkit/profiles/ce/small.xml 1. After the products and categories are created, make sure all categories are set as anchors. Run this SQL query: UPDATE catalog_category_entity_int SET value = 1 WHERE attribute_id = ( SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'is_anchor' ); 1. In the Admin panel, create a deeper category structure: * Move Category 2 under Category 1 to nest it deeper in the tree. 1. Try to open a category page in the Admin panel using a URL like: /admin/catalog/category/edit/id/xx/

Adobe's page lists 2.4.8 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-65848. On Cloud, add ACSD-65848 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-65848/ 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

Sources

• Adobe documentation for ACSD-65848
• JSON API: /api/v1/patches/ACSD-65848