1 hour ago, JBW said:Do you had really >190.000 orders? If not something is going wrong here... If yes, congratulations, seems to be a well running shop and 900MB seems reasonable size for this amount of order data.
ps_smarty_cache_bkp sound like backup of Smarty Cache on DB, is this option still activated? If not you might want to backup this table into a file and remove it from DB
On this installation the number of orders is correct however we had some problems with a 1.5 version when i first started using PS and lost around 50k order history (my inexperience with cart software) and had to do a total rebuild in 2014, so this particular business has around 250k orders since end of 2012 im quite proud of it despite all the sticky tape holding the cart together 
and if im totally honest would have given up on PS if it wasnt for the help of you guys on this forum.
i looked at ps-smarty-cache-bkp and considered if this was a backup entry in the database and after digging down into the entry there have been no additions to this table since 13-8-20 this also coincides with a major issue we had when we got hacked and we had to dig deep and do some major fixing of the site,
I have added a snippet below sorted by date (newest entries at the top), im far from an expert hence my question here and if those entries are safe to delete thats 100mb saved.
