1 hour ago, Prestachamps said:1. The information in regards to field id_address_delivered set to 0 can be deleted from ps_cart_product. You could empty the entire table, but you need to understand that all carts will be emptied (not that it would count too much, however some visitors who placed products into carts and left it there, they will need to read it again). Personally I would delete all the information's which are older than 30 days!
Yep that sounds good to me, good advice thanks
I'll start by emptying old entries and see if there's any changes regarding speed.
2. Delete all expired cart rules- however there is no magical solution there. I presume your add to cart is slow as well!? The add to cart could/can be optimized, but again needs some smart changes
That's what I am doing through a little script that I cron run every month
Indeed, add to cart is not slow as well, it's slow as HELL ! 😉. If you have any infos, or insights to share I'm all ears.
Thanks for your answer !
I'm going to follow your advices.
Best regards