28 minutes ago, Prestashop Addict said:Hi, this is "normal" if you have a huge histories of orders. But you can also check INDEX in database, because some migration modules add a join table.
I've checked the query and I don't see any strangeness, other than a join added by xpay module (a payment gateway). But I have the same speed even after disablign the module.
This is the query: https://pastebin.com/Z8LWhC7P
More or less 300k orders