I had a similar problem with one of my huge news portals, website was spending resources and I got a soft warning from host. What I did was just split my website into sections, archives via subdomains. For example 2023.mywebsite.com etc.
You can ask your host if that would help if you split your website in multiple databases etc.
