yes right

it won't hurt anymore then :)
you shouldn't have any upgrade problems, AFAIK Erwin has removed that col long time ago already and didn't get in trouble..

nevertheless if you just remove the mod query and don't install the mod thing into forum.php (of my file) and also don't improve the whos' online on forumhome queries with my hacking advices, mods wouldn't be highlighted anymore (just supermods and admins would..)

is that means after removing moderator querys from index.php , i have to apply other querys to other files ?

a little confused ...

;)

no, no other files are affected :)

hmm, maybe i've posted a bit complicated.

There is the online now feature on forumhome right?
and if you have enabled the moderatorhighlightin, all your online mods show up bold.
if you remove the mod query above and do not change the part which generates the current online users, all normal mods wouldn't be bold anymore :)

Now the result is 'Page generated in 0.26656604 seconds (43.08% PHP - 56.92% MySQL) with 50 queries.' Since I turned off the vBportal left colum display.

One question, how can I optimize it even more? :knockedout:

well i don't know without knowing your index.php ;)

you can look into my way to combine some queries and try if you can do so yourself on other queries :)

Thanks for the tip, but I am not quite good at php as you are.

well, also i started from a not so experienced level ;)
with time you'll learn how to do these things :)

i'd help you, but i really don't have any time left these days.

whoa..... Dramatic change for me. Very Very Very good hack indeed.

Before:
After:
a full 4 queries! a great improvement for a few changed lines!
MORE MORE! :D

thx, i do what i can to find some more ;)

btw. you should reduce your gzip level from 9 to 1.
the 9 isn't so much better in compressing, but the load of a server increases.