Introduction
To increase performance, it is possible to move older data from the production database to a separate archive database.
The archiving functionality needs 3 databases:
Production
Archive
Views (database for reporting on production and archive)