The moment you have quite a lot of records, the files is getting quite big and if the archive data can be in a separate db, it will have a huge impact on reports, backups, etc..

This way you can keep your archives for a longer period not affecting your real-time data.

Regards