Slow database access

[azurtem]

Hi

I have noticed significant latency recently with my Prestashop (v8.2.1) hosted by Informaniak (cloud server with SSD storage).

When I try to display a customer's summary, i.e. the page that displays their information, lists their carts, orders, products viewed, addresses, messages, etc, with certain customers (who have placed several hundred orders), it can take several minutes (stopwatched !) to display. Is this normal ?

The same thing happens when I create an order in BO. PS will first list existing carts and previous orders before allowing me to configure the order, which can also take a long time.

Do you have any advice or tips to remedy this, please?

Kind regards,

Yann

Edited Monday at 07:53 AM by azurtem (see edit history)

[Mediacom87]

Hi,

This is completely normal and problematic for large stores or stores dedicated to professionals.

For this type of store, I can only recommend my module for daily cleaning of a lot of useless or outdated data.

I will also be adding an option to this module that allows you to delete old orders (which are saved and stored for the legal period of 10 years).

 

 

[El Patron]

this module I've used several times for same exact issue, it works.  

https://www.aurone.com/blog/module-prestashop-archivebox-archiver-les-anciennes-commandes/

 

 

[azurtem]

@Mediacom87 : I already have such a module, which can wreak havoc if used without precautions

@El Patron, Thanks, this seems like a viable solution. Unfortunately Prestashop have been a little shortsighted in their ambitions when it comes to scalability