Best setup for large vBulletin forum?
I’m hoping to move a fairly large (3m+ posts) vBulletin installation to a DigitalOcean droplet, and while I’ve managed to get everything functioning there are two elements (viewing a thread, and posting a message) that are incredibly slow, cause up to 100% CPU usage and see MYSQL running at over 200%. This would happen when attempting to view as few as six or seven threads simultaneously.
Viewing any other sort of page is incredibly speedy.
I’ve tried it on a 2gb droplet with DigitalOcean’s LAMP bundle; I tried increasing the size to see if that would help, but it made no difference.
The forum’s database is several GB in size.
Is there anything obvious that I should or shouldn’t be doing - or is there a different droplet setup that I should explore?
Thanks in advance!