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

 

 

 

Translated with DeepL.com (free version)

[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).