V8x Any Prestashop Legend Here To Help To Fix a Problem, Please?

[Marc]

I upgraded from PS 1.6 to PS 8.0, and now the back office taking too long to load in some sections.

The first one is the catalog => products in the back office. It was taking around 350 ms in PS 1.6, and now it is taking around 12-13 seconds.

There is one query that is taking too much time. There are only around 5k products, but the query is showing an insane number of 23892103 rows.
It was showing only 20 rows in PS 1.6. Please see the attached image.

I hope someone here will help to fix the problem.

Kind Regards

Screenshot: https://drive.google.com/file/d/1SezJrLBlfIWxjDj2jBfBuc7OJcMaK18h/view?usp=sharing

 

[Coolt]

Try to verify your php version, it's not the same between 1.6 and 8.0.4 (the latest major version now is 8.1.0)

 

[Ponas]

cahange php from 7.4 to 8.1 and use cache module. On 8.1 speed very fast, in my site 20k products.