Help! Which modifications are the most server intensive?

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

Originally Posted by 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

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.