I have a web system that queries a MYSQL database, my tables have grown to such a degree that when you run some querys the results take a long time to process and sometimes they do not even reach a result, I have tried to optimize the query and I have searched for possible alternatives such as create views or add indexes etc, my question is whether it is professional and valid in the administration of a database to create "dead file" tables to put there the records of a table that are no longer used but they need to be conserved because the tables that are consulted will decrease in size and in this way, the result of the queries will be obtained faster.
Thank you very much everyone.