Query count.

[K33nny]

I was wondering what I should do about the query count on my forums. I've noticed lately after a few modification's that the count on showthread (going to newest post) is at 40. Here are some average's from different pages:

index.php: 31 queries
forumdisplay.php: 32 queries
showthread.php: 33 queries
showthread.php - latest post: 40 queries
usercp.php: 24 queries

Should I be concerned about the query count being above 30? What could I possibly do to lower the count?

forum.ewplanet.com (http://forum.ewplanet.com)

[K33nny]

Access Masks are off by the way.

[Tony G]

Stop installing hacks?

That's the really obvious reason why your queries are increasing. What hacks have you installed?

[K33nny]

Not alot honestly. As you can tell my forums are quite basic. :(

[Xenon]

31 queries for a vb2 index page is really not basic...
iirc basic was 15 queries.

as for showthread, 33 queries can be ok, it depends if these are fast ones or not, i'd suggest to remove some though...

Maybe you have just some hacks which are not well coded.
sometimes you can combine a few queries (take a look at my forumhome optimization for vb2, or a quite similar hack by filburt.)

there are some optimization hacks for vb2 which i suggest to install, or the much better way:
upgrade to vb3 :)

[K33nny]

I don't really like vB3, well I like it but it's got too much and I personally don't feel like disabling 75 things that I don't need or want. I'll just have to go back through everything I've installed and maybe remove stuff I don't really need. But honestly, I don't think I have THAT much installed.

I'll have to see though.

[Zachery]

I don't really like vB3, well I like it but it's got too much and I personally don't feel like disabling 75 things that I don't need or want. I'll just have to go back through everything I've installed and maybe remove stuff I don't really need. But honestly, I don't think I have THAT much installed.

I'll have to see though.
What 75 things do you not like about vBulletin 3?

[K33nny]

Read my post, I said that I didn't need them or want them. vBulletin2 gets the job done for what I want in a set of forums.

I got some of the pages to go down in query count, still going to work on a few other things.

[Xenon]

Well i also don't like some things in vb3, but the advantages really outweight the disadvantages.

Especially the efficient way of caching and queries...

[Zachery]

Read my post, I said that I didn't need them or want them. vBulletin2 gets the job done for what I want in a set of forums.

I got some of the pages to go down in query count, still going to work on a few other things.
vBulletin 3 gets the job done alot better at the end of the day and then some ;)

As stefan said the advantages realy kick the disadvantages, if you think there are any, in the bum ^^

[K33nny]

I understand that and if I had a better understanding of the template system I would've upgraded but I'll wait until after I get back from Bootcamp to do any of that.

[Zachery]

Its the vB2 template system with conditionals and CSS + orgianzed better ^^