How to lower 104 queries on frontpage?

[Tigga]

Try searching for something like this in your index.php file:

SELECT COUNT(threadid) AS total FROM thread WHERE dateline>

That's the query that's being executed 50+ times. If you remove that then it should lower the number quite a bit.

[Skyline_GT]

wa i see this
Page generated in 0.3105130 seconds (-5,883.75% PHP - 5,983.75% MySQL) with 29 queries.

[Gutspiller]

Today at 03:02 AM Tigga said this in Post #11
Try searching for something like this in your index.php file:

SELECT COUNT(threadid) AS total FROM thread WHERE dateline>

That's the query that's being executed 50+ times. If you remove that then it should lower the number quite a bit.

Yeah I have this chunk of code in my index

f ((!$forumperms['canpostnew'] and $showlocks) or $forum['allowposting']==0) {
          $forum['onoff'].='lock';
        }

        // prepare template vars
        if (!$showforumdescription) {
          $forum['description']='';
        }
        if ($bbuserinfo[userid]!=0) {
        $newforumthreads = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE dateline>$bbuserinfo[lastvisit] and forumid=$forum[forumid]  ");
        $newforumthreadvew = $newforumthreads[total];
       eval("\$forum[newforumthreadvew] = \"".gettemplate('forumhome_newforumthreads')."\";");
        
         }

How much of it do I remove?

[Gutspiller]

Today at 04:08 AM Skyline_GT said this in Post #12
wa i see this
Page generated in 0.3105130 seconds (-5,883.75% PHP - 5,983.75% MySQL) with 29 queries.

As we were talking above, guests don't see too many queries, but registered users see 98. We got a lot of stuff going on for registered users.

[Tigga]

PHP Code:

if ($bbuserinfo[userid]!=0) {
        $newforumthreads = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE dateline>$bbuserinfo[lastvisit] and forumid=$forum[forumid]  ");
        $newforumthreadvew = $newforumthreads[total];
       eval("\$forum[newforumthreadvew] = \"".gettemplate('forumhome_newforumthreads')."\";");
        
         } 


You can remove that bit of code and it will take care of the offending query. It's apparently counting the number of new threads in each forum since a user's last visit, so you will lose that hack, but IMO a hack like that certainly isn't worth an additional 50 queries on your homepage.

By the way, it seems you may have installed the microstats hack wrong...
Page generated in 0.5169800 seconds (-506.86% PHP - 606.86% MySQL) with 92 queries.
The query count seems to be accurate, but obviously the percentages aren't.

[SmEdD]

Queries may be wrong if you think about it. Everything way oever what it's suppost to be.

Are you useing vB 2.3. If you are theres a fix for the microstats that you might not of used.

[Brad]

07-10-03 at 03:57 AM Gutspiller said this in Post #4
Where would I find that and what exact parts would I remove, do you know? certain code I should look for?

in index.php

Find:

PHP Code:

$forummoderators=$DB_site->query('SELECT user.userid,user.username,moderator.forumid
                                  FROM moderator
                                  LEFT JOIN user
                                    ON (moderator.userid=user.userid)
                                  ORDER BY user.username');
while ($moderator=$DB_site->fetch_array($forummoderators)) {
  $imodcache["$moderator[forumid]"][] = $moderator;
  $mod["$moderator[userid]"] = 1;
}
$DB_site->free_result($forummoderators);
unset($moderator); 


Remove it.

Find:

PHP Code:

// Start makeforumbit
function makeforumbit($forumid,$depth=1,$permissions='') {
  global $DB_site,$bbuserinfo,$iforumcache,$ipermcache,$imodcache,$session,$accesscache,$usergroupdef,$noperms; 


Change to:

PHP Code:

// Start makeforumbit - modified
function makeforumbit($forumid,$depth=1,$permissions='') {
  global $DB_site,$bbuserinfo,$iforumcache,$ipermcache,$session,$accesscache,$usergroupdef,$noperms; 


Find:

PHP Code:

$listexploded=explode(",", $forum['parentlist']);
        while ( list($mkey1,$mval1)=each($listexploded) ) {
          if ( !isset($imodcache["$mval1"]) ) {
            continue;
          }
          reset($imodcache["$mval1"]);
          while ( list($mkey2,$moderator)=each($imodcache["$mval1"]) ) {
            if ( !isset($forum['moderators']) ) {
              eval("\$forum['moderators'] = \"".gettemplate('forumhome_moderator')."\";");
            } else {
              eval("\$forum['moderators'] .= \", ".gettemplate('forumhome_moderator')."\";");
            }
          }
        }

        if ( !isset($forum['moderators']) ) {
          $forum['moderators'] = ' ';
        } 


Remove it.

[Gutspiller]

Thanks.

Yeah, I've always had that problem with the microstats hack. I was never sure why it did it, but it was a small thing, I didn't care much about.