I dont have a good solution for this, but it is something that I have thought about in the past. I even toyed with trying to write a plugin to "move" tickets to an archive status and then relocate them into other tables, but decided that it was much too involved and time consuming.