Slow orders page in backoffice

[snuswdk]

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

[JeredBolton]

Have you switched on debug profiling? (This is a site wide setting so will output stuff on the shop's pages too).

 

To do this set _PS_DEBUG_PROFILING_ to true in config/defines.inc.php

 

Load the orders page in the back office and scroll the page down to get lots of timing information.