Interesting drawing for a splash screen on your site.

Like I was saying, there's no real need to reduce it with the number of members you've got now. You can rationalize the PM queries from 3 to 1 by replacing the current code in your index.php for PMs with this:
Quote:
$allpm=$DB_site->query_first("SELECT COUNT(*) AS messages,
SUM(IF(dateline>$bbuserinfo[lastvisit] AND folderid=0,1,0)) AS newpm,
SUM(IF(messageread=0 AND folderid=0,1,0)) AS unreadpm
FROM privatemessage WHERE userid=$bbuserinfo[userid] $ignoreusers");
$newpm['messages']=$allpm['newpm'];
$unreadpm['messages']=$allpm['unreadpm'];
|
Also, if you don't need to know the number of threads in the forums, or the name of the newest member etc. - each one of those takes one query. Just remove the relevant lines in your index.php. Make sure all templates are listed in your templatesused ="" variable at the top, or else each template called is an extra query too.