Hi,
We are experiencing a very slow loading, when we are loading the orders page in the backoffice. No other pages i slow loading.
We are currently having around 250k orders and growing with a almost 500-700 per day.
I started debugging the sql statment, but can't seem to find the bottle neck. If I remove the New client and I got the loading down from 10 seconds to 5 seconds (But still slow)
I have tested the sql statement both in production(Shared hosting), my own computer and a vps (Digital ocean).
Anybody who has a idea, what I can try next?
We are currently running prestashop 1.6.7