On most of the projects, the amount of orders (and items) keeps growing over time. On some of them, it reaches millions of items, ~80% of which - is just historical data.
Nevertheless, this data is still being used in order tables while searching, using order matrix, OMS state machine or operations in picking app. Tables, as well as indexes are growing and MySL queries becomes slower and slower overtime, causing general performance degradations, deadlocks, etc.
As a solution to those performance issues an "archiving" feature could be introduced. Old historic data could be moved to other tables, and not being mixed with the active one-s