Archive old fiscal year data

[brian_pond]

That’s a complicated topic, with no easy solution. Recommend reading this thread:

Has anyone successfully managed to Archive old Data from ERPNext?

I have a system with a database of 5gb and growing larger by 100mb every 3 weeks. When the database reached 4gb everything started slowing down. I added a bunch of resources: doubled the memory doubled the vCPU count added 50gb to the disk size increased gunicorn workers increased pool sizes added badnwidth All this made very little improvement in speed of operation. I believe I have found the tipping point of the frappe/erpnext database handling ability. I need to know if anyone has EVER f…