Optimizing Forumhome

Ok, what this Hack does is it reduces the ammount of queries on forumhome by caching the moderatorlist and by optimizing most of the queries used on index.php


I'd really appreciate getting feedback how it reduces serverload on greater boards

On an unhacked vb index.php (pm enabled accesmask disabled) it reduces the ammount of queries from 19 to 15
my experiments have shown, that the queries are faster than the normal ones, too....

[Xenon]

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

[erdem]

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

a little confused ...

[Xenon]

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

[Xyphen]

Originally posted by Xenon
wow, good server if it's that fast with 55 queries

but i think you should optimize index.php more than just with my hack

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:

[Xenon]

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

[Xyphen]

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

[Xenon]

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.

[VeoMorphine]

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

[Roderik]

Before:

Page generated in 0.50040603 seconds (27.94% PHP - 72.06% MySQL) with 27 queries.
[Debug Mode OFF] [PHP v4.1.2] [GZIP enabled - level 9] [Server Load: 0.08 ? 0.17 : 0.22]

After:

Page generated in 0.51396000 seconds (26.39% PHP - 73.61% MySQL) with 23 queries.
[Debug Mode OFF] [PHP v4.1.2] [GZIP enabled - level 9] [Server Load: 0.22 ? 0.13 : 0.16]

a full 4 queries! a great improvement for a few changed lines!
MORE MORE!

[Xenon]

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.