PrestaShop very slow in the order tab ("config" very slow in profiler)

[Kaudy]

Hello,

The order tab in the admin is very slow. I don't even know what caused this, it's like it happened with no reason. The order tab can take more than 100s to load, and after the first load, a few seconds. But when you log out, remove cookies, start again, then the tab is slow again.

I enabled the profiler, I hoped that the issue was a plugin but it doesn't looks like it, as it's the "config" that takes so much time and SQL queries that seems to be native to PrestaShop. The website is running on shared hosting, but it was working fine before.

I'm sending the profiler as an attachment so that it's easier to read, but the main issues is :

- config 108765 ms

For a total load time of :

- Load Time 108951 ms

Do you have any idea?

 

 

Best regards,

 

 

 

[Daresh]

Anything suspicious in the database? Like for example large number of rows in the 'ps_configuration' table?

[Kaudy]

31 minutes ago, Daresh said:

Anything suspicious in the database? Like for example large number of rows in the 'ps_configuration' table?

There is 2 023 rows fr ~300kio. I don't see weird things, the last rows are from plugins Colissimo, Alma, PS CHeckout, Prestascan, pagespeed...

[Prestashop Addict]

Please can you specify PS, PHP versions

[Kaudy]

26 minutes ago, Prestashop Addict said:

Please can you specify PS, PHP versions

Hello,

PS version : 1.7.8.10

PHP version : 7.4.33

[metacreo]

Perhaps you installed some module recently? Do you have any modules with interactive capabilities installed ? For example, a delivery module that requests a carrier.
How much customers you have in customer table and how much orders ?

[Kaudy]

5 minutes ago, metacreo said:

Perhaps you installed some module recently? Do you have any modules with interactive capabilities installed ? For example, a delivery module that requests a carrier.
How much customers you have in customer table and how much orders ?

The last installed plugin is PrestaScan, nothing new for the carriers as far as i know. There is 623 customers and for the orders 566. It took 1.56s to load this time, it's really when there is no cookie or maybe cache, I don't know. Sometimes it's 100 seconds, sometimes 1.50...

[metacreo]

actually it's normal for prestashop. The thing is that while there are no serious loads everything flies fast... especially on the developers' test servers

I have the same problems.. only they become noticeable after 10,000+ orders or clients. Apparently my hardware is more powerful. I optimize some shops, but the thing is that there is little left of the modern prestashop and it code looks more like the old 1.6

My advice to you: if you need to keep the entire database constantly, then switch to another platform. while it's not too late. Prestashop is not developed for huge stores, it is exclusively for making money via support.

In your specific situation, I think that cleaning the database will help you. Old orders, old clients, statistics and connection tables.

Also, you will be tormented on a regular hosting, think about a dedicated server.

If you have prog skills I attached scripts who help you.

SQL_CLEAN_PS.zip

[WisQQ]

1 godzinę temu, Kaudy napisał:

There is 2 023 rows fr ~300kio. I don't see weird things, the last rows are from plugins Colissimo, Alma, PS CHeckout, Prestascan, pagespeed...

Try disabling each at a time and see if there is any difference. It will narrow down to which module can cause this.

[metacreo]

Open site in Mozilla FF
Press F12 to open dev console
In dev console go Network Tab

Open site  admin and go to orders. Clean in dev console all records and go to order page who slow.

Inspect requests in dev console.

How many requests you see in dev console at bottom when opening order page ?  And which request is slowest in de console table?

Edited March 27 by metacreo (see edit history)