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

[DrkFusion]

Seems not to work

[DrkFusion]

Sometimes it says 13 queries, and sometimes it sasy 34, sometimes it says 32, and sometimes when i refresh t says 13. Whats wrong?

[nuno]

That's just the cache doing it's job, caching
Oddly enough i get 15 queries for logged out users and 12 for logged in, what's the catch?

[Xenon]

@Drk: if your qureies change so strong, the hack is working perfectly
as nuno said, that's caching

@nuno: hmm, the caching is optimized for logged in users, it should also work for most of the logged out ones, but, i have to optimize that part i think

@Aaron: yes it's easy i think, i'll help you when i've more time so i can look into TECKs hack
I think speed was the better chose

[DrkFusion]

This is great
Great job Xenon

[jeffj]

most excellent... I had it up and running on my test site in about 5 minutes...and it worked great!

then I moved index.php to my production site... and ....too bad I forgot to add the cache table to my production site....but that only took about 10 seconds and I beat everyone before they saw the mysql error that I did...

it works great and I love it!

- jeff

[Xenon]

thanks for the kind words

i found out it works nearly perfect, just a small thing i had to change before it will be moved into full releases

i think it will be there before next year

[freeshares1]

:clicks on install:

It works very well and i have noticed that my forum home loads a lot quicker.

[DrkFusion]

One for forumdispay and showthread would be really nice
This is the next best thing to microstats

Thanks to Xenon my forumhome:
Page generated in 0.09714496 seconds (75.75% PHP - 24.25% MySQL) with 13 queries.

[fury]

Great hack! It = teh winnar. I now get 0.2-0.3 second forumhome generation times, with 18 queries if cached, 25 if not.

Since I have the persistent mark forums read hack by ethank installed I had to modify part of that in member.php to be able to get forum lights to turn off, but other than that, it looks to be working perfectly.

[fury]

One for showthread would be HUGE

[fury]

I noticed after installing this hack, total post count is off by 10... there are 111979 post records in the database but the sum of the replycount column is 111989.. there are 10 extra posts somehow (10 is how many forums I have which have posts in them, but I don't know why this would have any effect)

Running the counters again didn't help.

[X-Fan]

Just installed this, and it works great! My forum home page went from around 32 queries down to 19!

I'm wondering if there's any way to add this to vbHome for those (like me) who use that as their site's portal page?

[DrkFusion]

Vote Xenon for vB Dev :-p

This is a great method, I would love this for the all of vb

[Xenon]

*ggg* thx Arunan

@X-Fan: When i have more time and completly finished this beta, i will work with TECK on an inclusion into vBhom (lite)

@fury: There are two possibilities:
1. your counters are wrong (update your counters, be sure you'll do in the right order (first threads then forums)
2. you have orphan posts which don't appear in any threads...