vb.org Archive - 135 queries in forum home !!

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)

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.

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