+1 Million posts forum = SLOOOWW

[Xorlev]

Yes, it's possible. There's a few configurations you could go with. You could have a load balancer in front of two webservers with two copies of MySQL running in a master-master configuration. Or the webserver <-> database server configuration. If you ever went with three you could do the same configuration with the webservers, only a backend database server. I'm not too sure what kind of configuration would work the best with vBulletin however.

[mano1.com]

ah great thanks for the information Xorlev

I can't seem to be able to give you a positive "rep" on this board

OK so I am not 100% happy with the speed still, HOWEVER by disabling the "show new rep comments and new posts" plug-in, I just accelerated my forum back to a much more acceptable speed.

[Marco van Herwaarden]

Since your board is already running for some time (asuming this) and you just upgraded, the database might also have become fragmented. You could try to backup the database, restore into a fresh database, and then use this new one. It might make some difference.

[mano1.com]

ah that's interesting, I didn't know about doing this... Thanks for the tip.
We are about to move to the new and fast server, so I will probably do this at the same time.

[GrendelKhan{TSU]

Originally Posted by Protoman

switch your search system to use the mysql fulltext search engine under vbulletin options.. that should make a difference, also try out the vb datastore cache option, makes a huge performance improvement (you change that in config.php)

is this only useful for big boards? I got a small board... .but I still would like to optimize. even at a small size I have performance issues.