[Tigga]

If you'll add 'index_rotm' and 'index_buddy_none' to the templatesused section at the top of the file, that will remove 2 of the queries. Apparently 4 others are coming from your vBstats hack in your global.php file...


--------------------------------------------------------------------------------

Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1263689994812
Time after: 0.12737095355988

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.12776899337769
Time after: 0.12833797931671

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.12861597537994
Time after: 0.12964296340942

table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where


--------------------------------------------------------------------------------

Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13033998012543
Time after: 0.13225495815277

--------------------------------------------------------------------------------



As for the polls, make sure that you have the poll templates and that you have "RAND" entered for the polls forum id.
The threads from you private forums will only be visible to those who have permission to view them, assuming you have your forum permissions set correctly.