My Perch Shop tables have a huge amount of data, `shop_cart` for example has over a million rows. If I understand correctly, this table holds temp data whilst a customer is checking out. So is this data safe to truncate? It would probably be safer to remove everything apart from the last 50 entries just to be on the safe side.
I'm just looking for conformation as to whether this is safe and in fact recommended?
If that is, is there any other tables that would be safe to truncate on a regular basis to stop the database becoming too large. Should I even be worried about how large the database is?