Cart table is growing with unknown reason

[ivanoman]

Hi all, 
I'm using PS 9.1 and I noticed that the cart table is growing without having a real visitors choosing the product. 
Is there any way to avoid this? 
In the mean time I wrote a script that remove the table if not connected to anything. 

 

Quote

DELETE c, cp
FROM xxxx_cart c
LEFT JOIN xxx_orders o ON o.id_cart = c.id_cart
LEFT JOIN xxx_cart_product cp ON cp.id_cart = c.id_cart
WHERE o.id_cart IS NULL
  AND c.date_add < NOW() - INTERVAL 30 DAY;

What do you think ? 
 

Merry Chrustmas !! 
IM