Hi there,
Our website got pretty slow after importing 1000+ cart rules (based on category + shipping method).
After enabling profiling, we can see about 1000 queries for carte rules on the homepage when logged in.
If you aren't logged in, everything works fine.
By the way, when profiling is on, hooks information are not showing any hooks - read it was normal on 1.7.3, but is there a way to reimplement it ?
-
I've speeded up the website by deleting unwanted carts from unregistered customers but I'm concerned about the table :
- ps_cart_product showing more than 100 000 rows - is it safe to empty it ? or at least those with the field id_address_delivered set to 0 ?
Questions :
1) Which table can be cleaned up safely ? I already use this module https://mypresta.eu/modules/administration-tools/database-optimization.html
2) Any optimization possible for the carte rules ?
Thanks much
Prestashop 1.7.3 on dedicated server