I'm a little confused about cart-abandonment. I made the cba shop with help of this book. It stores the shopping cart in a table in a database.
However in the exercises there is nothing said about the spam left in the temp database, the database fills up and if you have many visitors it fills up fast. What is the best way to deal with this problem, is there a script which knows when a user closes its browser and then deletes it's cart. The book says that it wants to save it for analysis, but if I keep it I must delete the entries weekly and I’m not really happy with that.