Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Sep 2008, 03:48
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
Help! Which modifications are the most server intensive?

For some reason my server keeps hanging at the most random times. I am wanting to find out what modifications are the most server intensive. I am willing to remove any that are really high in server intensity, except those that are a need to the servers.

Advertisement System By TZ

Affiliation Without Marquee

AME - The Automatic Media Embeder

Auto Database Backup

Automatic Tagging

Automatically Added Friend

Ban Thread User

Check4SPAM

Custom Links

Cyb - Auto Reply

Cyb - PayPal Donate

Cyb - Visitors in Last X Hours

Delete Visitor Messages Every 30 Days

Force Users to Read a Thread

FractalizeR: Registration Form AJAX Enhancements

Full Quickreply And Quickedit

Generators

Get Direct Links

GTPrivate Message Quickreply

GTPrivate Messages Enhanced Listing

HS - External Signature Image Size Limiter

Limited Guest Viewing

Mass PM Members

Mini YouTube/full url for member profile

Moderation Auto-PM

Moderator Application System

Multiple Login Detector

nCode Image Resizer

Nick's Forum Home Announcment

Prevent Doubleposts

Real ip detection

Register Rules Timer

Report Bad PM

Separate Sticky and Normal Threads

SK Dismiss Notices

Spiders Display on Forumhome

URL Redirect

UserCP Navbar Menu

vBSEO :: Sitemap Generator

vMoods

Welcome Headers

Yet Another Award System 4.0

ZH - Closed Thread Mark-Up

ZH - Default PM Title

ZH - Meta Tags

ZH - Page Execution Time
Reply With Quote
  #2  
Old 03 Sep 2008, 20:33
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Do you have a modification which lists the number of queries on the bottom of the pages for the admin? Start looking at that and seeing which pages make the most 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
  #3  
Old 04 Sep 2008, 02:17
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
Originally Posted by Lynne View Post
Do you have a modification which lists the number of queries on the bottom of the pages for the admin? Start looking at that and seeing which pages make the most queries.
There's a modification for that? Can you link me to it?
Reply With Quote
  #4  
Old 04 Sep 2008, 05:19
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Microstats - load times, server loads, queries, uncached templates
__________________
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
  #5  
Old 16 Sep 2008, 08:08
dirtyfeast dirtyfeast is offline
 
Join Date: May 2008
Well not to jump in on this conversation. Below is what I have for my site. Is this good, or bad.

Page generated in 0.32535 seconds with 80 queries (2 queries for uncached templates) [Server Loads: 1.46 1.66 : 1.53]
Uncached templates: cv_ffl_rss_button_in_footer (1)
Uncached templates: nick_announce (1)

Any info is always welcomed in making things run smoother, and faster.
Reply With Quote
  #6  
Old 16 Sep 2008, 15:05
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
For what page?

Although, 80 queries for any page is a lot, IMO.
__________________
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 16 Sep 2008, 17:05
dirtyfeast dirtyfeast is offline
 
Join Date: May 2008
I am sorry. That is for the Forumhome page. If the main forum page is Forumhome than thats what it is.
Reply With Quote
  #8  
Old 16 Sep 2008, 18:42
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
My index.php page has 25 queries. I don't know what else you have displayed besides the normal forums/sub-forums, but 80 seems like an awful lot of 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
  #9  
Old 21 Oct 2008, 01:32
dirtyfeast dirtyfeast is offline
 
Join Date: May 2008
So is 80 more than I should have.
Reply With Quote
  #10  
Old 21 Oct 2008, 03:52
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
I think 80 is a whole lot of queries. If I were you, I'd spend some time trying to combine some of those or get rid of them.
__________________
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
  #11  
Old 21 Oct 2008, 06:32
Lizard King's Avatar
Lizard King Lizard King is offline
 
Join Date: Jan 2005
Real name: Mert
Evem 25 queries is a lot , 80 queries is insane. The first thing you should do is start uninstalling all those bad coded modes one by one. Lynne you should do the same
__________________
Mert G÷kšeimam / Crawlability Inc.

DepKaš | vBSEO 3.3.0 - vBulletin Search Engine Optimisation
Reply With Quote
  #12  
Old 21 Oct 2008, 06:37
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
It's not only how many queries, but how efficient they are. You could have 10 queries that may be slower than 25 efficient, quick ones.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #13  
Old 21 Oct 2008, 07:48
Lizard King's Avatar
Lizard King Lizard King is offline
 
Join Date: Jan 2005
Real name: Mert
Sure you can Hanson but if we are talking about index page then adding that many queries example 15 is not good. You can have a highly customized with tons of additional options on index page with an average of 15 queries. I am really amazed how people gets 25 or more queries.
__________________
Mert G÷kšeimam / Crawlability Inc.

DepKaš | vBSEO 3.3.0 - vBulletin Search Engine Optimisation
Reply With Quote
  #14  
Old 21 Oct 2008, 07:57
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
I'm not saying that 25 queries is not excessive on Forum Home, I agree with you. However, you cannot judge "server intensiveness" on amount of queries alone .
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #15  
Old 21 Oct 2008, 15:53
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by Lizard King View Post
Evem 25 queries is a lot , 80 queries is insane. The first thing you should do is start uninstalling all those bad coded modes one by one. Lynne you should do the same
I know it is. 15 of those are to grab some torrent threads/stats. I've already cut down on a lot of the computation time (I like to show percentage done) by writing a cron job to compute those numbers. I'm not sure what else I can do to cut down on them. The page load time is fine, so I'm not too worried about it right now (too many other things to do to worry about that!).
__________________
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
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 15:02.

Layout Options | Width: Wide Color: