table sales_flat_quote_item_option extremely large

Question

Whilst investigating as to why my magento 1.8.2 store DB was very large (over 7.4gb) I ran a query to see the table sizes and sort in order and I discovered that the sales_flat_quote_item_option table is 6880.58 MB in size which is most of the DB space. I do use custom options extensively (every product) but I think this cant be right. My guess is that this data is the custom option data customer have filled in when placing an order but for some reason it is not purged when an order is place or it is due to orders not being completed and the data remains. Would this be correct?

How do I deal with this? Is it ok to truncate this data or delete anything over 30 days for example? Im not sure if this is safe or not so am asking for advice.

Also , is there a way to stop this building up? For example having a cron hat deletes data over a certain age? Again, any advice is appreciated.

Answer 1

So after further investigation it seems it is "probably" safe to delete this data and there is an extension that can help in this

https://github.com/fbrnc/Aoe_QuoteCleaner

I installed this and ran the cron (setting it do delete 50000 at a time) until I have reduced my tabel size to 143MB with it keeping data from the last 30 days.

Site seems to be running normally so far but will have to keep an eye on it for any issues