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

[Aaron1]

Originally posted by Boofo


Did you check it while viewing a thread or just a forum? It works good in the forums, it's while viewing a thread (posts) that the forum titles are gone from the forumjump drop down listing.

Yes it looked all good! Btw you got a fast webserver. Everything runs smoothly. I wish my site was like that!

[Herman]

Hmm I'll try my own on forumdisplay, it shouldn't be too awful hard....

[Parker Clack]

Xenon:

Great hack. I look forward to seeing what you can do to optimize showthread.

Parker

[Thehandyplanet]

Yes, great Hack!

[Dvd]

You have an error in your SQL syntax near '\'0\',
lastpost int(10) unsigned NOT NULL default \'0\',
lastupdate int(10) un' at line 2

Any ideas?

[Xenon]

@DVD: a bit more information would be nice.....
Where do you get this error, which file, line and so on...

[MartynJ]

Am I missing something? I installed the latest version of the hack, and my index page looks indentical, doesn't load any quicker, and doesn't use any more or any less queries. Also, how do I know if I'm using the cached version, and how do I force a cache update?

[Xenon]

Well, you won't see any difference, visually
it just reduces the querie ammount if it reads from the cache.

The cache would be updated, whenever a new post is made, that's also how you force an update

so if you've installed the newest version, go to forumhome, you'll have about 19 queries (normally) then just do a reload, without a new post has been made, and the qurey ammount should be about 14.
if you don't have the effect, you have probably made a mistake while installing

[Aaron1]

I have a problem, it could be related to this hack. But i am not sure. After trying to optimize the forumhomepage, i was advised to move 'The Latest XX Threads Hack' after the '} // if $cacheupdate' line. But now the hack is not working properly anymore, it does show, but the problem now is, that it also shows topics from a private forum.

What do you think of this? Is this a cache related problem? Or just the fact because i moved it below the specified line?

[Xenon]

yes, that's a problem. These two hacks don't work together properly. It's because the viewingpermissions are just read out from the db when the cache is updated, but it won't if the script reads from the cache. That is one of the queries which are reduced when reading from cache

i don't know the hack of latest XX but maybe, you can add the threadinfo into the cache also, so it should be working

as said, i can't code such workarounds for other hacks whil beta-phase but maybe i find a way after the full release

[nuno]

By adding a new mod to the forum it will not be displayed on forumhome Xenon

[MartynJ]

I installed it slowly as per the instructions. Though I noted a faster load, the queries were always at 23 for logged in users, and 16 for logged out users. Is it possible that the template recording the number of queries made is also cached?

[Xenon]

@nuno: Yes you are right, just make a new post that there is a new mod and you'll see next time on forumhome he will be displayed

it just won't display him as long as the script reads out from the cache

@MartynJ: Hmm, maybe a bug with a hack you've installed.
The newest version works perfect on all my test boards (hacked and unhacked)
can you create a test account so i can see it on your board

[nuno]

Done and fixed

[Aaron1]

Originally posted by Xenon
i don't know the hack of latest XX but maybe, you can add the threadinfo into the cache also, so it should be working

Hmm, sounds very simple but how do i do that?
Well i guess, there will be more hacks that might have some trouble with your optimize(cache) hack?

Well for now i have uninstalled the latest XX threads hack, because i was forced to choose between speed and functionality. Yes, i have chosen speed, but hey! I got 19 queries now!