[5.x]: Slow queries for product relation fields

[jmauzyk]

What happened?

Description

After migrating to Craft 5, I'm experiencing slow queries for product relations fields, around 4600 ms per field according to the debug toolbar. If there is a product relations field within a matrix field, some CP pages just won't even load.

Craft CMS version

5.9.20

Craft Commerce version

5.6.2

PHP version

8.2.30

Operating system and version

Linux 6.12.76-linuxkit

Database type and version

PostgreSQL 14.20

Image driver and version

Imagick 3.8.1 (ImageMagick 7.1.1-43)

Installed plugins and versions

No response

[linear]

COM-554

[nfourtythree]

Hi @jmauzyk

Thank you for your message.

Could you please send a backup of your database and copies of your composer files to support@craftcms.com referencing this issue.

This will allow us to look into this further.

Thanks!

[nfourtythree]

Hi @jmauzyk

Thank you for reporting this and providing the extra data via support.

A fix for this has been pushed up and will be included in the next release of Commerce.

To get this early, change your craftcms/commerce requirement in your project's composer.json to:

"require": {
  "craftcms/commerce": "5.x-dev as 5.6.2",
  "...": "..."
}

Then run composer update.

Thanks!