QUALITY PATCH

ACSD-67603: Sitemap generation has long processing times for products with image inclusion enabled

Sitemap generation has long processing times for products with image inclusion enabled. Quality patch ACSD-67603 for magento/module-sitemap applies to Magento Open Source and Adobe Commerce 2.4.6 to 2.4.7-p10.

Categories
Other, Catalog/Product
Components
magento/module-sitemap, magento/module-catalog-permissions
Origin
adobe-commerce-support
Since QPT
1.1.71

Issue

Sitemap generation has long processing times for products with image inclusion enabled.

Steps to reproduce

1. Generate a catalog of ~6,000 products across two websites. 1. Enable sitemap generation with Add Images into Sitemap set to ALL. 1. Measure sitemap generation time. 1. Repeat with Add Images into Sitemap set to NONE and compare performance. 1. Confirm that products without images don't cause unnecessary delays, regardless of image inclusion settings.

Adobe's page lists 2.4.6 - 2.4.7-p7 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-67603. On Cloud, add ACSD-67603 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-67603/ 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

Packages across compatible versions (1): magento/module-sitemap
Packages across compatible versions (2): magento/module-sitemap, magento/module-catalog-permissions

magento/magento2-base >=2.4.6 <2.4.8

Magento Open Source
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, 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6
Adobe 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, 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6
Patch file
patches/os/ACSD-67603_2.4.7-p6_v2.patch
  • vendor/magento/module-sitemap/Model/Batch/Observer.php (added)
  • vendor/magento/module-sitemap/Model/Batch/Sitemap.php (added)
  • vendor/magento/module-sitemap/Model/Config/Source/GenerationMethod.php (added)
  • vendor/magento/module-sitemap/Model/ItemProvider/Batch/Product.php (added)
  • vendor/magento/module-sitemap/Model/ResourceModel/Catalog/Batch/Product.php (added)
  • vendor/magento/module-sitemap/Model/ResourceModel/Catalog/Category.php
  • vendor/magento/module-sitemap/Model/ResourceModel/Catalog/CategorySelectBuilder.php (added)
  • vendor/magento/module-sitemap/Model/ResourceModel/Catalog/Product.php
  • vendor/magento/module-sitemap/Model/ResourceModel/Catalog/ProductSelectBuilder.php (added)
  • vendor/magento/module-sitemap/Plugin/Cron/Model/Config/Backend/SitemapPlugin.php (added)
  • vendor/magento/module-sitemap/etc/adminhtml/system.xml
  • vendor/magento/module-sitemap/etc/config.xml
  • vendor/magento/module-sitemap/etc/crontab.xml
  • vendor/magento/module-sitemap/etc/di.xml
  • vendor/magento/module-sitemap/etc/module.xml
  • vendor/magento/module-sitemap/i18n/en_US.csv

magento/magento2-ee-base >=2.4.6 <2.4.8

Magento Open Source
—
Adobe 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, 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6
Patch file
patches/commerce/ACSD-67603_2.4.7-p6_v2.patch
  • vendor/magento/module-catalog-permissions/Plugin/Sitemap/Model/ResourceModel/Catalog/CategoryPlugin.php (added)
  • vendor/magento/module-catalog-permissions/Plugin/Sitemap/Model/ResourceModel/Catalog/ProductPlugin.php (added)
  • vendor/magento/module-catalog-permissions/etc/di.xml

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.