[SOLVED][BO] Order list very very slow

[ale123]

I've seen the, sometimes, the order list page in BO could be very very very slow. That's my case, about 20 seconds for the query.

Some one solved by reinstalling PS from scratch, this is not possible in my case, it's a live website with A LOT of orders, PS was installed from scratch some months ago and then products and orders migrated from the old prestashop with a migration module.

What should I check to see why the query is slowing down ? Any fix that doesn't require a reinstall ?

PS 8.1.7

PHP 8.2

MariaDB with cache enabled (the same with cache disabled)

Buffers higher than the full database size, so database could easily kept totally in RAM

OPCache enabled

[Prestashop Addict]

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.

[ale123]

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

Edited November 6, 2024 by ale123 (see edit history)

[ale123]

No, wait, the JOIN added by the xpay module doesn't use any index. I've added the missing index and now seems to work as expected.

[Prestashop Addict]

Great 😉 Don't forget to change your title post by adding [SOLVED] and add a Thanks or Like to the good answer, this will help community.