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]

Ok, uploaded a little modified file now
Moved the thread to Full Releases

thanks to all who helped me in the betaphase

[NuclioN]

i get a gzinflate parse error at the top of the forum index after replacing the old code with the new. (?)

[Dean C]

Awesome i'll try this on my localhost tonite

[Xenon]

@NuclioN: How old was your last version?
the last update justs changes a small if-clause nothing with the gzinflate function...

as a tip, just empty the whole forumcache table and it should work again

[Dean C]

Wow this works wonders Xenon..

Reduced my testboard from 19queries to 14queries when dont on a fresh install

- miSt

[Smoothie]

How well does this work with hacks that are installed?

[Boofo]

There's some that won't work very well (or at all) with it, that is why I had to un-install it. Great idea, though.

[Smoothie]

thats a shame.

[Dean C]

Yep well i'm sure there's a way around it and Xenon will guid you all the way

[Xenon]

@Smoothie: it depends on the hack, subforums on forumhome for example works perfect and has a huge effect on reducing queries.

if you are a little experience you can nearly make every hack to work with it.

but it doesn't work with this hack:
# of users browsing on Forumhome