vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How to lower 104 queries on frontpage? (https://vborg.vbsupport.ru/showthread.php?t=55168)

Tigga 07-12-2003 08:02 AM
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 07-12-2003 09:08 AM
wa i see this
Page generated in 0.3105130 seconds (-5,883.75% PHP - 5,983.75% MySQL) with 29 queries.

Gutspiller 07-12-2003 09:10 AM
Quote:
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

Code:
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 07-12-2003 09:13 AM
Quote:
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 07-12-2003 04:59 PM
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 07-12-2003 09:04 PM
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-13-2003 09:51 PM
Quote:
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 07-14-2003 02:27 PM
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.


All times are GMT. The time now is 02:12 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01361 seconds
  • Memory Usage 1,766KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (5)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete