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

[NTLDR]

Thanks for releasing Xenon, I'm going to be sure to test this one

[Xenon]

i hope i'll get good results by you NTLDR

[Dean C]

Yea i'll test this one out - sounds awesome :P

[Chris M]

Sounds good

Will install

Satan

[JulianD]

I'm going to test it for my new site! Thanks Xenon!

[Xenon]

i have to thank everyone who test it to bring back some feedback to me

if it works as it should i'll create other hack like that (have some ideas )

@All: my PM-solution worked wrong (damn) the file is updated with the well known pm-query, you should use this instead

[Lanigironu]

This is great!

My queries used to be at 48, and now dropped to 38.

I know this is extremely high, so are there any ways to lower it any more?

[Boofo]

Xenon, I did a re-fresh with 21 queries, it jumped to 23 and on another refresh, it went down to 17. I figure it was the cache kicking it. Its there a way to add this:

$totalviews=number_format($countthreads['views']);

to the query you have to make one less query if we are using this?

Also, the code for this:

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');

must be a little different in 2.2.9.

[Xenon]

Uploaded new version with small bugfix
be sure you also make the table change to have lastupdate in it


Boofo: Well, yes it can be changed, if you use the threadtable instead of the forum-table, but the forumtable is faster, and on an unhacked vb229 i've used the optimized version

once it's out of the beta i can make it for you or post it here ok?

must be a little different in 2.2.9

hmm, no i've compared it with an unhacked vb229 file, maybe your fle is hacked...

Xenon, I did a re-fresh with 21 queries, it jumped to 23 and on another refresh, it went down to 17. I figure it was the cache kicking it.

Yes there are 3 extra queries compared to an normal forumhome call when the cache is updated, but at least 3 less to a normal one if read out from the cache.
But the additional queries are very fast from what i know compared to the others