vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   quick query (https://vborg.vbsupport.ru/showthread.php?t=76431)

Carnage 02-16-2005 12:27 PM

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.

Deaths 02-16-2005 02:47 PM

284 is a lot of queries...

noppid 02-16-2005 03:21 PM

Quote:

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


That is an understatement! It's downright rediculous!

Zachery 02-16-2005 03:55 PM

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.

Carnage 02-16-2005 04:58 PM

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 :/

Zachery 02-16-2005 05:10 PM

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?

Carnage 02-17-2005 05:52 PM

took some doing but its down to about 30 queries.

Zachery 02-17-2005 06:32 PM

Showthread should not generate much more than 15..

what hacks have you installed.


All times are GMT. The time now is 03:00 PM.

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.02075 seconds
  • Memory Usage 1,722KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete