i need function to make wordpress use custom tables for old posts by jobssss

I have a site with about 24,000 posts and 200 posts daily and the database will get huge soon. So I plan to transfer the old posts to custom tables to reduce the database load. There’s no need to show these posts on the site… (Budget: $30 USD, Jobs: MySQL, PHP, WordPress)