vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   135 queries in forum home !! (https://vborg.vbsupport.ru/showthread.php?t=230247)

kimof911 12-15-2009 12:41 PM

135 queries in forum home !!
 
hi all

i have a serious problem...

my forum home has 135 queries...which lead into problems with my host and asking me to optimize my site...

i dont know what is the problem...i did all optimization solutions...Vb optimize 1.3.2....disabled most of my plug ins and hacks...

so how to know where is the problem...

where is these queries and for what !!??

Kaelon 12-15-2009 01:26 PM

I have only heard of these sorts of queries happening under vBulletin 4 (which is known to generate hundreds of queries on a view request); not vBulletin 3. If you are using stock vBulletin 3 without any mods (turn-off your plug-in system completely from the vB Options panel), you should be getting around a dozen queries a page or less.

kimof911 12-15-2009 01:31 PM

u r right Kaelon...

i have disabled all plug-ins and got 8 queries in forumhome...

there must be a bad-programmed plugin that leads into these crazy queries....

i am trying now to check for every plugin to discover which is the problem-maker :)

Reeve of shinra 12-15-2009 02:21 PM

Tell us what mods you have installed

Brandon Sheley 12-15-2009 02:24 PM

enable the mods one by one until you find the one(s) that produce the most queries

Lynne 12-15-2009 03:07 PM

Quote:

Originally Posted by Kaelon (Post 1931091)
I have only heard of these sorts of queries happening under vBulletin 4 (which is known to generate hundreds of queries on a view request)

Not on forumhome, which is what we are talking about here (read the thread title).


If you have a test site setup that is a duplicate of your live site, you can turn on debug mode and see what those queries are and then track them down. However, on a live site it is probably best to turn off the plugins, see how many queries are run, and then turn them on one-by-one to see which is adding all the queries.

Carnage 12-15-2009 03:21 PM

Quote:

However, on a live site it is probably best to turn off the plugins, see how many queries are run, and then turn them on one-by-one to see which is adding all the queries.
I'd be tempted just to put the site behind a .htaccess file for 10 mins while using debug mode to find the problem. Either that or look into one of the mods that enables debug mode for specific users only.

kimof911 12-15-2009 08:11 PM

i have found a plugin which cause about 80 query ...that was an old plugin from a previous 3.6.5 upgrade...i am now now using 3.8.3 for 6 months...

now my forumhome has 17 query with a very good performance and that is very good with the server resources and server cpu loading time

thanks guys...really thanks

jboyd 12-16-2009 06:12 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=196422&highlight=kxdesign" target="_blank">https://vborg.vbsupport.ru/showt...light=kxdesign</a>
is a great mod for trying to debug your forum and track down queries

Brandon Sheley 12-16-2009 07:40 PM

Quote:

Originally Posted by kimof911 (Post 1931360)
i have found a plugin which cause about 80 query ...that was an old plugin from a previous 3.6.5 upgrade...i am now now using 3.8.3 for 6 months...

now my forumhome has 17 query with a very good performance and that is very good with the server resources and server cpu loading time


thanks guys...really thanks

care to share the mod you updated?
glad you got it figured out :up:


All times are GMT. The time now is 05:46 AM.

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.01087 seconds
  • Memory Usage 1,731KB
  • 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
  • (10)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