QUALITY PATCH

MDVA-36309: Products search by attributes is slow in the admin grids

Products search by attributes is slow in the admin grids. Quality patch MDVA-36309 for magento/module-catalog-search applies to Magento Open Source and Adobe Commerce 2.3.2 to 2.4.2-p2.

Categories: Admin, Performance
Components: magento/module-catalog-search, magento/module-catalog-staging
Origin: adobe-commerce-support
Since QPT: 1.1.3

Issue

Products search by attributes is slow in the admin grids.

Steps to reproduce

Perform search in various admin grids with different types of searchable attributes.

Adobe's page lists 2.4.2 - 2.4.2-p2 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 MDVA-36309. On Cloud, add MDVA-36309 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its MDVA-36309/ 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

magento/magento2-base >=2.4.2 <=2.4.2-p2

Magento Open Source: 2.4.2-p2, 2.4.2-p1, 2.4.2
Adobe Commerce: 2.4.2-p2, 2.4.2-p1, 2.4.2
Patch file: patches/os/MDVA-36309_2.4.2.patch

vendor/magento/module-catalog-search/Model/ResourceModel/Search/Collection.php

magento/magento2-base >=2.3.2 <2.3.6

Magento Open Source: 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2
Adobe Commerce: 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4, 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2
Patch file: patches/os/MDVA-44146_2.3.5.patch

vendor/magento/module-catalog-search/Model/ResourceModel/Search/Collection.php

magento/magento2-ee-base >=2.4.2 <=2.4.2-p2

Magento Open Source: —
Adobe Commerce: 2.4.2-p2, 2.4.2-p1, 2.4.2
Patch file: patches/commerce/MDVA-36309_2.4.2.patch

vendor/magento/module-catalog-staging/etc/di.xml

magento/magento2-ee-base >=2.3.4 <2.3.6

Magento Open Source: —
Adobe Commerce: 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4
Requires: MDVA-31343
Patch file: patches/commerce/MDVA-44146_2.3.5.patch

vendor/magento/module-catalog-staging/etc/di.xml

magento/magento2-ee-base >=2.3.2 <2.3.4

Magento Open Source: —
Adobe Commerce: 2.3.3-p2, 2.3.3, 2.3.2-p2, 2.3.2-p1, 2.3.2
Patch file: patches/commerce/MDVA-44146_2.3.2.patch

vendor/magento/module-catalog-staging/etc/di.xml