The Arcive of Official vBulletin Modifications Site.

Help with reducing Queries · **Released**: 03-07-2003

Just installed the MicroStat hack and my main forum page show 150 queries!!

http://www.powwows.com/gathering

Any suggestions for reducing this?

Thanks!

amykhar · #2 03-07-2003, 01:53 PM

I have a hunch that it's the number of active users today that is getting you. I had a similar problem with one of my styles, and turning on debug showed the queries all stemmed from that hack trying to find a template. I tinkered with things a bit (what I did won't apply to you because I turned it off for default members in addition to making sure all the templates were in the list.)

So, that is where I would start looking. Turn debug mode on, look at explain for that page, and you will have an idea of where to begin.

Amy

pgowder · #3 03-07-2003, 01:57 PM

How do you run the explain and turn on debug?

amykhar · #4 03-07-2003, 01:59 PM

You turn debug on by putting debug=1; in your config.php file. Then you bring up your forum home page like this:

http://www.powwows.com/gathering/index.php?explain=1

pgowder · #5 03-07-2003, 04:42 PM

Ok, got that. And I have a huge page of info. How do I determing the problem?

pgowder · #6 03-07-2003, 04:49 PM

Your guess was right!

forumhome_todayloggedinuser is showing up a few hundred times!

Did you remove that hack or rework it?

amykhar · #7 03-07-2003, 04:52 PM

Let me go look at the code again and see if I can find the problem.

Amy

pgowder · #8 03-07-2003, 04:55 PM

Thanks!

amykhar · #9 03-07-2003, 05:25 PM

It seems you are using the version where the names don't display on the forumhome, but instead pop up in a new window.

When I had problems with this hack, it was only when I used a style that didn't display the hack. If I used a style that displayed it, queries were fine.

Did you modify the hack yourself, or did you use the version released by Mystic that creates the popup window? You might need to go to that hack's thread and have Mystic look at it because I see somebody else had issues with queries and it was never resolved.

The number of queries you have depends on how many people have logged in for the day.

Amy

pgowder · #10 03-07-2003, 06:29 PM

Actually, I'm using the one where they all show, but I removed that template reference from forumhome hoping to reduce the queries.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05002 seconds Memory Usage 2,284KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!