Hello community, our ERPNext / Frappe instance has really grown and we’re really happy to have chosen Frappe! It really comes with batteries included.
However, we would like to archive our Version history from time to time. Is there a built-in feature for that? Our version contains about 2.7 billion data.
I don’t think version tables should be deleted You might need it for forensics in the future.
If you’re sure it’s causing slow downs then an alternate would be a partitioning table (somewhat risky so do at your own volition)
Or backup and drop previous data. Deleting 2B+ rows isn’t really possible, better option is to copy recent data and drop table like described here: Big DELETEs - MariaDB Knowledge Base
To use this you’ll have to backup manually using mariabackup and avoid inbuilt backups. (Somewhat risky as it’s “manual” step but you can build a system around it)