Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 15 Dec 2009, 13:41
kimof911 kimof911 is offline
 
Join Date: Sep 2008
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 !!??
Reply With Quote
  #2  
Old 15 Dec 2009, 14:26
Kaelon's Avatar
Kaelon Kaelon is offline
 
Join Date: Jan 2002
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.
Reply With Quote
  #3  
Old 15 Dec 2009, 14:31
kimof911 kimof911 is offline
 
Join Date: Sep 2008
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
Reply With Quote
  #4  
Old 15 Dec 2009, 15:21
Reeve of shinra's Avatar
Reeve of shinra Reeve of shinra is offline
 
Join Date: Oct 2001
Tell us what mods you have installed
Reply With Quote
  #5  
Old 15 Dec 2009, 15:24
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
enable the mods one by one until you find the one(s) that produce the most queries
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #6  
Old 15 Dec 2009, 16:07
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by Kaelon View Post
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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #7  
Old 15 Dec 2009, 16:21
Carnage Carnage is offline
 
Join Date: Jan 2005
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.
__________________
www.giveupalready.com

If you want/need to contact me, best thing is to pm me on that site, username Carnage.
Reply With Quote
  #8  
Old 15 Dec 2009, 21:11
kimof911 kimof911 is offline
 
Join Date: Sep 2008
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
Reply With Quote
  #9  
Old 16 Dec 2009, 19:12
jboyd jboyd is offline
 
Join Date: Nov 2008
http://www.vbulletin.org/forum/showt...light=kxdesign
is a great mod for trying to debug your forum and track down queries
Reply With Quote
  #10  
Old 16 Dec 2009, 20:40
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
Originally Posted by kimof911 View Post
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
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 10:58.

Layout Options | Width: Wide Color: