Since Erpnext is designed for small-midsize businesses. I’m thinking it would be useful if it has option to manage duration of data storage.
Considering performance issue for long time usage, then I believe this option may help a lot.
I’m thinking something like:
Option on Company where we can set year for how long the system will keep the data e.g. 5 years then when entering 6th year, 1st year data is automatically deleted.
Manual delete button so user can decide when to delete with option e.g. keep last 5 years.
This way will help a lot on managing large scale of data due to long duration of usage so the performance is maintained.
The data to be deleted is transaction records only, not master data.
It’s just my suggestion to improve ERPNext.