ACSD-49973: Improved performance fetching bundled products via [!DNL GraphQL]

The ACSD-49973 patch improves performance fetching bundled products via [!DNL GraphQL]. This patch is available when the [!DNL Quality Patches Tool (QPT)] 1.1.30 is installed. The patch ID is ACSD-49973. Please note that the issue is fixed in Adobe Commerce 2.4.7.

Affected products and versions

The patch is created for Adobe Commerce version:

• Adobe Commerce (all deployment methods) 2.4.4-p2

Compatible with Adobe Commerce versions:

• Adobe Commerce (all deployment methods) 2.4.4 - 2.4.4-p3

Issue

Performance degradation occurs when fetching bundled products via [!DNL GraphQL].

Prerequisites:

Create 2000 bundle products using the Performance toolkit.

Steps to reproduce:

1. Enable the [!DNL DB] query logger:

   bin/magento dev:query-log:enable
   

2. Execute the following [!DNL GraphQL] query:

   {
     products(
       search: "bundle"
       pageSize: 2000,
       sort: { relevance: DESC }
     ) {
       total_count
       items {
         name
         sku
       }
     }
   }
   

3. Check var/log/db.log for requests to the catalog_product_bundle_selection table.

Expected results:

Requests to the catalog_product_bundle_selection table should not be present in the var/log/db.log.

Actual results:

There are 2000 requests to catalog_product_bundle_selection table which are triggered at the same time, which cause performance degradation.

Apply the patch

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

• Adobe Commerce or Magento Open Source on-premises: [!DNL Quality Patches Tool] > Usage in the [!DNL 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 [!DNL Quality Patches Tool], refer to:

• [!DNL Quality Patches Tool] released: a new tool to self-serve quality patches in our support knowledge base.
• Check if patch is available for your Adobe Commerce issue using [!DNL Quality Patches Tool] in our support knowledge base.

For info about other patches available in QPT, refer to [!DNL Quality Patches Tool]: Search for patches in the [!DNL Quality Patches Tool] guide.