ACSD-49973: Performance degradation occurs when fetching bundled products via GraphQL

Categories

GraphQL, Performance

Components

magento/module-bundle, magento/module-bundle-graph-ql, magento/module-catalog-inventory, magento/module-inventory-catalog, magento/module-inventory-catalog-search, magento/module-inventory-catalog-search-bundle-product, magento/module-inventory-catalog-search-configurable-product

Origin

adobe-commerce-support

Since QPT

1.1.30

Issue

Performance degradation occurs when fetching bundled products via GraphQL.

Steps to reproduce

1. Enable the DB query logger: bin/magento dev:query-log:enable 1. Execute the following GraphQL query: { products( search: "bundle" pageSize: 2000, sort: { relevance: DESC } ) { total_count items { name sku } } } 1. Check var/log/db.log for requests to the catalog_product_bundle_selection table.

Adobe's page lists 2.4.4 - 2.4.4-p3 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

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-49973. On Cloud, add ACSD-49973 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-49973/ 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-49973
• JSON API: /api/v1/patches/ACSD-49973