Help! Which modifications are the most server intensive?

[TheInsaneManiac]

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

[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.

[TheInsaneManiac]

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?

[Lynne]

<a href="https://vborg.vbsupport.ru/showthread.php?t=82900" target="_blank">Microstats - load times, server loads, queries, uncached templates</a>

[dirtyfeast]

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.

[Lynne]

For what page?

Although, 80 queries for any page is a lot, IMO.

[dirtyfeast]

I am sorry. That is for the Forumhome page. If the main forum page is Forumhome than thats what it is.

[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.

[dirtyfeast]

So is 80 more than I should have.

[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.

[Lizard King]

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

[Dismounted]

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.

[Lizard King]

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.

[Dismounted]

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 :).

[Lynne]

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!).

[noppid]

You should turn on debug and see what the memory footprint looks like.

As for queries, 25 is fine if they are written correctly. Any good hack is going to pull 1 to 5 records on indexes of tables likely cached.

Don't let 15 versus 25 come to mean anything unless you look at the queries in detail. I don't mean to start a query debate. To me, the math rules. Go with the math. No two situations are going to yield comparable results.

[TECK]

<i>As for queries, 25 is fine if they are written correctly.</i>
I find that 10 queries is a lot on a busy forum. Unless you are rich...
To me, server load rules... when we deal with servers and related software.

Personally, I would consult with my users what options I should trade: keep this remove that...
You should only install what is really needed on your board. Any extra product will affect your server performance, no matter how well it is written.