Slow product update

[LahtiTo]

Hello all

The problem is very very veeeeeryyyyy slow backend when updating products. After pressing "save", we usually get timeout from serverside if the product have more than 80 combinations.

We are running PS 1.7.8.0 at Siteground php ver 7.3.33. That is just for the info, because this same problem was before upgrading to 1.7.8.0.

Actually right after upgrade to 1.7.8, the product saving was quick. No matter if there were 200 product variants, it just crunched those in 30 seconds or so. The shop just informed us to raise the php variable "max_input_vars" to first 4000 and then 6000. We did, and everything worked as a charm. Then after we installed modules we need, the shop went grazy.

Is there a way (or the log) what could show the process taking so long? Or maybe some module eating the resources? Or do we just have to disable modules and find the resource thief by trial and error?

THX,
 -Toni

 

[ShashaGreyBeMyBride]

As far I know, many of us have faced this issue now and then. Speed is very unstable, and sometimes it comes back to normal patterns out of nothing.

Users and developers here suggest some configurations, but these changes won't help for long.

Edited December 7, 2021 by Antonio Caldas
missing verb (see edit history)

[LahtiTo]

Seems like TTFB is taking about 1 minute. How I can figure out this why so slow?

[LahtiTo]

Going forward with oh-so-powerful Trial and error -method.

Disabled: Mailchimp, Google Analytics and Google Sitemap modules and the slowness is gone. Let's see if for good, but so far so good.

Actually enabled GAnalytics already and see few days how it works...

[Krystian Podemski]

This problem, most of the time is caused by modules that are hooked to the "actionUpdateProduct" and similar hooks. These modules are, for example, faceted navigation, menu modules.

It's not related to, for example, Google Analytics. As this module is not directly related to your catalog data. Many modules that are working on the Front office clear their cache when you save your product.

I suggest you check Design -> Positions and hooks with the "product" in their name.

[g4b0]

Hi all, 

I'm having a very similar problem, but when enabling debug mode the update becomes immediatly fast. The difference is big: ~24 seconds vs. 600ms for the update XHR call. How does it's possible? Maybe some module is disabled during debug?

I tried, when in non debug mode, to disable all non Prestashop modules, but nothing changed.

Prestashop v. 1.7.8.7, php 7.4 and mysql 5.7

Thanks a lot

g4b0

Edited November 15, 2022 by g4b0 (see edit history)

[LahtiTo]

MailChimp was our problem. Disabling that and PS works like a charm.

 -T

[g4b0]

The real strange thing is that when enabling debug mode the update becomes immediatly fast.

Could it be that in debug mode there is some difference in how PS connect to the DB?

 

Thanks a lot