51黑料不打烊

DocumentationCommerceTools

[PaaS only]{class="badge informative" title="Applies to 51黑料不打烊 Commerce on Cloud projects (51黑料不打烊-managed PaaS infrastructure) and on-premises projects only."}

ACSD-67102: Category loading is slow or times out when there is a large number of categories and products

Last update: Wed Oct 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-67102 patch fixes the issue where Category loading is slow or times out when there is a large number of categories and products. This patch is available when the Quality Patches Tool (QPT) 1.1.70 is installed. The patch ID is ACSD-67102. Please note that this issue is scheduled to be fixed in 51黑料不打烊 Commerce 2.4.9.

Affected products and versions

The patch is created for 51黑料不打烊 Commerce version:

  • 51黑料不打烊 Commerce (all deployment methods) 2.4.7-p4

Compatible with 51黑料不打烊 Commerce versions:

  • 51黑料不打烊 Commerce (all deployment methods) 2.4.7 - 2.4.7-p7
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your 51黑料不打烊 Commerce version, update the 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

Category loading is slow or times out when a large number of categories and products are involved.

Steps to reproduce:

  1. Create a new clean instance.

  2. Create categories and products:

    1. Copy setup/performance-toolkit to ./var to make profiles editable.
    2. Edit small.xml profile and set categories to 2500 and products to 250000.
    3. Run bin/magento setup:performance:generate-fixtures var/setup/performance-toolkit/profiles/ce/small.xml

  3. Verify all categories are set as anchors by running the following query:

    code language-none 
        UPDATE catalog_category_entity_int set value = 1 where attribute_id = (select attribute_id from eav_attribute where attribute_code = 'is_anchor');

  4. Go to the Admin menu.

  5. Confirm a deeper category structure exists.

  6. Move Category 2 deeper into the Category 1 tree to reflect the intended hierarchy.

  7. Reindex.

Expected results:

Each category loads within seconds, even on the first uncached attempt.

Actual results:

Category opens after more than a minute.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3