Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 06-04-2003, 02:20 PM
Mustang5ohhh Mustang5ohhh is offline
 
Join Date: Dec 2002
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 59 queries ???

My forumhome is generating this :

Page generated in 0.40923595 seconds (82.23% PHP - 17.77% MySQL) with 59 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP disabled] [Server Load: 0.13 » 0.16 : 0.16]

This seems a "little" high to me. I have a few hacks installed ... top10stats ... welcomehack ... categorie banners and few others.

I had the Mod drop down ... before uninstalling it I had 63.

Is there a hack that will tell me what queries are being run ?

I need to get this fixed ... page load for members on dial-up is crazy.

Thanks in advance.
Reply With Quote
  #2  
Old 06-04-2003, 03:58 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

enabel debug mode of your board and call index.php with parameters explain=1&showqueries=1
Reply With Quote
  #3  
Old 06-04-2003, 04:55 PM
Mustang5ohhh Mustang5ohhh is offline
 
Join Date: Dec 2002
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Xenon

I had trouble getting debug to work. Added the line to the config.php and uploaded ... still wasn't on according to the microstats hack I have installed.

I did find something that was adding queries ... having my forum depth set to 3 was adding 33 queries. I set it back to 2 and down to 26.

Is 26 an acceptable # ???

Thanks again.
Reply With Quote
  #4  
Old 06-04-2003, 05:12 PM
WEForums WEForums is offline
 
Join Date: Apr 2003
Location: Jacksonville, Florida
Posts: 195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think 26 is pretty acceptable. I have 27.

Check out Xenon's hack. https://vborg.vbsupport.ru/showthrea...threadid=46848 (If you haven't already)

I think someone else did another one...maybe filburt.
Reply With Quote
  #5  
Old 06-04-2003, 05:25 PM
assassingod's Avatar
assassingod assassingod is offline
 
Join Date: Jul 2002
Posts: 3,337
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

filburts :https://vborg.vbsupport.ru/showthrea...threadid=53455
Reply With Quote
  #6  
Old 06-04-2003, 07:32 PM
cirisme cirisme is offline
 
Join Date: Jan 2003
Posts: 136
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
I had trouble getting debug to work. Added the line to the config.php and uploaded ... still wasn't on according to the microstats hack I have installed.
I noticed that too, both on my test forum and live forum. But, it is in debug mode even if it says its not. Debug mode and showqueries are invaluable optimization tools.

Quote:
Is 26 an acceptable # ???
Not bad. I have 21, but that's cause I went wild and added two queries.
Reply With Quote
  #7  
Old 06-05-2003, 05:15 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

FYI the debugmode has to be enabled in config.php, when you enable it in phpinclude or somewhere else it wouldn't help
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:05 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03720 seconds
  • Memory Usage 2,213KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete