[5.x]: Commerce slows down Craft for 300-400%

[wmdhosting]

What happened?

Description

Testing Commerce.. now and what i see when i enable Commerce
All Pages non related to Commerce , Section index pages. entries and so on..
load much slower 300-400% .. than without commerce..

when i disable commerce it.. all pages load quite fast...

Craft CMS version

5.1.1

Craft Commerce version

5.0.3

PHP version

8.2.16

Operating system and version

CloudLinux v8.9.0

Database type and version

MySQL 8.0.36

Image driver and version

No response

Installed plugins and versions

[linear]

PT-1700 [5.x]: Commerce slows down Craft for 300-400%

[lukeholder]

I have just attempted to reproduce and couldn't see much difference:

But my site could be totally different to yours.

Could you possibly send to support@craftcms.com the following:

DB backup
composer.json
composer.lock
config/project

...and we will see if there is anything obvious going on. Thanks.

[nfourtythree]

Hi @wmdhosting

Thank you for reporting this. We managed to track down a performance improvement using the files you sent.

We have pushed a fix for this which will be included in the next release of Commerce 5.

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

"require": {
  "craftcms/commerce": "5.x-dev#3815a75e8e9f4c515a7c098a547282a42ca3425d as 5.0.6",
  "...": "..."
}

Then run composer update.

[lukeholder]

5.0.7 is now out with this fix! Thanks.