I'm doing some backups ( prepping for Joomla update & CB update and CBsubs update) and I notice that cbsubs_history table has grown to more than half a million rows ( table size 1.9 GB!).
My question is... is it possible to PRUNE this? Is there a built in function somewhere? (If not, how can I best prune it manually without breaking stuff?).
I have the whole thing downloaded for historical purposes, anyway. I was thinking for starters, I could run some SQL to delete all rows that were linked to any accounts that have been deleted? Would there be any gotchas I should be aware of? (other dependent tables linked?)
I guess that in a way it's nice (probably strictly necessary???) to have the historical data retained for all current members.
But on the other hand I'd love to be able prune out everything that's more than say two years old... but I suspect there would be some "issues" :huh:
CBSubs 4.1 does not rely on the History and logs tables. It is there purely for documentary and logging purposes. In some countries, this is even required by applicable laws.
2 types of entries are recorded: Change-logs to all table changes, and error logs. You have filters for those in the History view. All warnings and errors on the site while executing CBSubs are also logged in it.
You can prune whatever part you want of that table in the database. The only effect will be the displayed number of changes, and that not all changes are visible anymore.
At this time there is no built-in function to prune that table automatically or manually, and there are currently no plans to add that in the near future.