PS 1.7.5.0 / 1.7.6.1 very slow on updating products with attributes

[zanpo]

I'm confronting myself with a very slow admin after upgrading to PS 1.7.5.0 and even on 1.7.6.1, the same problem, when I try to update something from products (for example stock, or description or title) the "save" button takes forever to update the product.

I enabled dev mode, and I get this performance result (when updating attribute stock):

Quote

Performance metrics
221501 ms
Total execution time

From the attached image, "controller" eats up a lot of time, but I don't know what it refers to.

Any ideas why is this happening, the store has around 5500 products with attributes and 60 categories.

Server specs:

Quote

 

nginx/1.16.1

PHP: 7.2.24

memory limit: 1024M

execution time: 600s

 

Edited November 22, 2019 by zanpo (see edit history)

[tuk66]

Try to set both

define('_PS_MODE_DEV_', true);
define('_PS_DEBUG_PROFILING_', true);

in the /config/defines.inc.php file to profile the page. I mean it should provide more detailed view.

[zanpo]

Thanks, I've tried it, but I don't see any useful information, the timings here are in ms:

Edited November 24, 2019 by zanpo (see edit history)

[selectshop.at]

You did some SQL optimization, or are you using default settings for your SQL-DB ?

Try also opcache optimizations named here:

 

[tuk66]

So the total execution time is 221 seconds even it says the loading time is 551 ms?

[Mercader Virtual]

The problem can be related to a registered hook in a module.

classes/stock/StockAvailable.php, line 619 executes this hook:
 

Hook::exec('actionUpdateQuantity',
array(
	'id_product' => $id_product,
	'id_product_attribute' => $id_product_attribute,
	'quantity' => $stock_available->quantity,
));

In my case, I had module "Mail alerts" enabled which uses that hook. Since my server wasn't configured to send mails, it was causing a huge bottleneck.
It was taking around 20 sec. on saving/deleting a product!

After disable the module it took 2 secs on PHP 5.6. I tested it on products with around 10 combinations each.

 

Edited May 10, 2020 by Mercader Virtual (see edit history)

[RSI-SHOP]

Zgadza się - też zastanawiałem się czemu tak muli jak edytuje kombinację. Wyłączałem ten moduł i działa jak nie wiem  Dzięki.