Theres no one worst hack, however 300+ hacks could be disasterous.

You really need to scale back properly.

Surely there are some hacks worse for queries than others?
for examply people have promptly said about VB shout...

The thing is all the hacks i have installed are being used in 1 way or an other,
I have removed about 10 - 20 hacks over the last few days, ones that werent
really used or were installed to test it out....

I was always led to beleive that the PsiStats were server intensive, so i disabled
this only to find no difference lol

When debug mode is on what does the (3) mean next to the template, (3) is
just an example, There is one thst (74) i think it is?

Many times hacks can be fine tuned.
- uncached templates
- limit what page hacks show on vs. many pages.
- use links to open new pages w/ extra info vs. all the stuff on 1 page.

I have 30-40 products @ the moment and MAX at 21 queries on a few pages AVJ. 12 on most.

60 does sound a few 2 many...

what would you say is a 'safe' number of queries.

Before I read this thread I didn't even know about debug mode, and I wouldn't have known if 60 queries was good or bad...

I've just checked my forum and i'm running 11 queries on forum home, 18 on forum display, and 13 on show thread.

How would you rate those figures?

Thanks guyz

So...would 3 uncached templates cause a lot of issues or aint either here nor there?

I run about 30 hacks (including BOTH arcades) and forumhome queries run at 22 which seems to be fine.

I have an entirely unnecessary but nice hack on the front page that adds 3 queries so if I ever had any issues I could easily drop to 19.

As a rough guide - when you reach 20 it's worth looking at why, as that's an upper amount. Past 25 and you should start to question if there is a problem, 30+ will almost certainly be the sign of a problem hack or hacks and start to affect performance.

Everyone is telling you the same thing.

There is no way in hell that 100 hacks are being used by 584 members. Let alone 200. You need to stop "being a sucker for new toys" and run your site as if you want people to come back. Your forum index looks like you've taken every possible thing you could ever use and just gone "that'll do" and thrown it in.

I don't even know what your site is about.

A few pointers:-
- REMOVE SOME DAMN HACKS. You don't need 200. I have twice as many members, and they don't need 200 hacks.

- REMOVE some forums. You have SIXTY ONE forums - and that isn't counting subforums. Of course your server load is going to be high. I'm no vBulletin expert, but I'm assuming that would create at least a few extra queries. For example, do you really need a forum for each different type of Pay TV hack? If you only have like 10 posts in five related forums, stick them together and have 50 in one. It looks busier, which will draw more people in.

- Your page is taking 9.8 seconds to be GENERATED. Not downloaded. Not displayed, but generated. That's 9.8 seconds that I have to wait before your page even starts to display in my browser. If I wasn't purposefully trying to check your site out so I could help you out, I would have left by then.

In short dude, your attitude pretty much bites in this topic. You say "which are the most server intensive hacks?", everyone says "you have a gazillion hacks, no wonder...", you say "yes, but which ones are the most server intensive?"

The answer is simple. It isn't the quality of the hacks, or the amount of resources that each one uses, its the fact that you have 200 hacks that you don't need. Your site could easily run without ANY hacks other than the portal mod. Do yourself a favour and listen to these good people.

And I pray that you aren't using a shared host. Think of the other customers who are trying to run their site and are getting massive delays thanks to your love of "toys"...you wouldn't like it. Be responsible.

bashy, I wanna be serious with you for a minute, so please take the time to read this.

I visited your site, and I wouldn't be suprised if people are leaving as soon as they go there, you have way to many. I saw your thread for a new moderator and the postbit is MASSIVE for you. Like triple the size of any postbit i've seen.

I have to agree with what was said earlier, you're instaling everything.

I for one would be happy to help you go through your hacks, tell you what I wouldn't recommend keeping, and see if you agree.

I would encourage you to think about this, 9 seconds for generation is way to much. I'll help you uninstall or whatever if you want the help, but I wouldn't recommend leaving it as is.

Anyway let me know if you want a hand, and maybe someone else would be willing to help.

All I know is that there are so many helpful hacks, and you've just gone way overboard.

Kurt Barker
Administrator - Commodore Life Forums

"statistics - top 5" ==== this is useless and shit. on most forums, it's always got the same members. drop it.

- get rid of all the moving text, especially in the title.
- get rid of the random arcade games box, or at least clean the code and cut down the queries to not display so much info about each arcade game - no one (member or guest) gives a crap about any of that info.
- popular keywords and tags - useless. it doesn't make sense what they are, and i wouldn't use them personally if i was a member.
- the actual forum listing's tables are ++++ed.. all the widths are wrong sizes, needs a lot of fixing.
- go change the settings for Vb - make sure the views for threads are only updated every 'x' hours.