Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 02-16-2005, 12:27 PM
Carnage Carnage is offline
 
Join Date: Jan 2005
Location: uk
Posts: 760
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default quick query

my forums have been getting increasingly slow recently... so i was wondering if this was normal...

anyway i wanted some feed back on the speed of other peoples forums when displaying threads in linier mode. i've got page display times and query numbers at the bottom of my pages and i think that its quite high... for 40 posts per page i get this: "Page generated in 15.55674 seconds with 284 queries" My thought is that somewhere probably in my rpg stats hack its using an excessive ammount of queries. thus slowing it down. If this is the case, i'll rewrite it to be more efficient :P but if other people are having similar issues i'll just put it down to a universal problem.
Reply With Quote
  #2  
Old 02-16-2005, 02:47 PM
Deaths Deaths is offline
 
Join Date: Oct 2004
Location: Europe, Belgium
Posts: 679
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

284 is a lot of queries...
Reply With Quote
  #3  
Old 02-16-2005, 03:21 PM
noppid noppid is offline
 
Join Date: Mar 2003
Location: Florida
Posts: 1,875
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Deaths
284 is a lot of queries...

That is an understatement! It's downright rediculous!
Reply With Quote
  #4  
Old 02-16-2005, 03:55 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Carnage-
my forums have been getting increasingly slow recently... so i was wondering if this was normal...

anyway i wanted some feed back on the speed of other peoples forums when displaying threads in linier mode. i've got page display times and query numbers at the bottom of my pages and i think that its quite high... for 40 posts per page i get this: "Page generated in 15.55674 seconds with 284 queries" My thought is that somewhere probably in my rpg stats hack its using an excessive ammount of queries. thus slowing it down. If this is the case, i'll rewrite it to be more efficient :P but if other people are having similar issues i'll just put it down to a universal problem.
You've ++++ed up somthing with the rpg hack.. 285 is freaking insane, anything over 40~ is, unless its some sort of page that is rarely access.
Reply With Quote
  #5  
Old 02-16-2005, 04:58 PM
Carnage Carnage is offline
 
Join Date: Jan 2005
Location: uk
Posts: 760
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i disabled the rpg hack and dropped it to 120 queries... i can account for ~80 of them but yeah seems the rpg hack was throwing 164 queries out :s from looking at the code it throws out about 4 queries per post... whoever wrote that needs shooting.

the 80 i can also cut down... i thought numbers of that order were going to be my problem... i hate having to fix other peoples code :/
Reply With Quote
  #6  
Old 02-16-2005, 05:10 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Carnage-
i disabled the rpg hack and dropped it to 120 queries... i can account for ~80 of them but yeah seems the rpg hack was throwing 164 queries out :s from looking at the code it throws out about 4 queries per post... whoever wrote that needs shooting.

the 80 i can also cut down... i thought numbers of that order were going to be my problem... i hate having to fix other peoples code :/
80 querys:? Still

What hacks do you have installed?
Reply With Quote
  #7  
Old 02-17-2005, 05:52 PM
Carnage Carnage is offline
 
Join Date: Jan 2005
Location: uk
Posts: 760
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

took some doing but its down to about 30 queries.
Reply With Quote
  #8  
Old 02-17-2005, 06:32 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Showthread should not generate much more than 15..

what hacks have you installed.
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:32 AM.


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.04318 seconds
  • Memory Usage 2,221KB
  • 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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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