With over 3 million posts in the database, things are starting to creak, if not actually break down. Although I haven't officially diagnosed database size as being the reason it is slower these days, it seems to have gotten progressively worse as the seasons pass.
So, that's an issue. I'm open to suggestions on how to handle this.
Given that this is database size driven, I could possibly buy another license of IPB and offload a decade worth of posts, make it archive only. This will affect post counts, etc... on active board.
I could just also just delete those posts. Not a big fan of that option.
Or, perhaps there is a server tweak I have missed or there is something happening in the background that is causing the long page load times. Regardless, I'll need a plan of action for this season...
Thoughts?