[Scott MacVicar]

That is not an improvement btw.

It will actually make things worse as its dependant on the size of your tables.

And please please please realise that number of queries is not everything, its the cost of the query including read / write access to the files and the number of rows that have to be scanned.

For example
SELECT * FROM poll LEFT JOIN thread ON (poll.pollid=thread.pollid) ORDER BY dateline DESC LIMIT 1

is more costly than two seperate queries
SELECT MAX(pollid) as PID FROM thread;
SELECT * FROM poll WHERE poll.pollid=$var[PID]

Also consider posting on the Server Config forum on vBulletin.com and getting eva2000 to optimize your apache and mysql settings.

Are you running two seperate servers? If not then thats the way to go because you have alot of users online.