Prestashop 8.1 product modification very slow to open

[newgeneration]

Hello everyone, I have a problem with the installation of prestashop 8.1 and php 8.1. After successfully importing 15000 products, if I try to open any product in the backoffice side, it takes almost 1 minute. Enabling the debug and leaving the product open, I noticed that the resource blocking everything is doctrine.. a scrrenshot is attached.. is this a bug of prestashop 8.1? how can i solve? Thanks in advance...

Edited August 4, 2023 by newgeneration (see edit history)

[Nickz]

How much do you allocated for php memory in the php.ini file of your shop?

How much RAM do you have in your server? Specs would be great to see.

[newgeneration]

hi, 

memory_limit 4096M. The server has 12GB of ram

[Nickz]

Those 15000 Pictures how much do those weight?

[newgeneration]

the problem is evident even without images

[newgeneration]

 

I checked the logs and every time I try to modify a product the following error is present.., help

mod_fcgid: stderr:   thrown in /var/www/vhosts/pneumaticidiretti.it/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php on line 737

[Nickz]

5 hours ago, newgeneration said:

mod_fcgid: stderr:   thrown in /var/www/vhosts

You might get lucky with that solution:

Quote

When I change execution mode to FastCGI things start to work normally.

 

 

https://stackoverflow.com/questions/61642533/mod-fcgid-stderr-php-fatal-error-call-to-undefined-function-bcpow

[musicmaster]

Can you have a look which query takes up so much time by enabling _PS_DEBUG_PROFILING_ in /config/defines.inc.php?

20 hours ago, newgeneration said:

mod_fcgid: stderr:   thrown in /var/www/vhosts/pneumaticidiretti.it/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php on line 737

When I look at that code line I see the following:

That suggests you might have a look at your caching settings.