How do we delete a fiscal year, (example a fiscal year which is 7-8 years ago), which has been closed and in which transactions have been entered. There should be such a facility as otherwise that the database will balloon in size and become unmanageable.
MariaDB does a lot of internal optimization and partitioning. Lets cross that bridge when we come to it.