Version: 1.00, by Xenon
Developer Last Online: Oct 2023
Version: 2.2.x
Rating:
Released: 12-19-2002
Last Update: Never
Installs: 94
No support by the author.
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....
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Originally posted by 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
Don't have that one installed, but I do have a hack for Photo Post installed.
@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...
My counters were already updated like a billion times. Doing the orphan posts option didn't find anything either.
Originally posted by nuno By adding a new mod to the forum it will not be displayed on forumhome Xenon
Quote:
Originally posted by 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
Xenon, it shouldn't work that way IMO.
It would be tons cleaner if it was only updated when a new mod is added.
Current version waits for a new post/new thread for being made and then updates the moderator db table.
Not so useful for busy boards.
@fury: As i know the orphan post function just finds posts where threadid is 0.
but there can also be some posts where threadid > 0 but the thread they belong to is deleted.
my hack shows not the ammount of posts that are saved in the db, just the ammount of posts which can be viewed by at least the admin. So i'd say my method is better, normally the ammount should be the same, but if you've had a little problem some time ago you can have this difference
@nuno: It's an optimization of the loading time of the forumhome.
When you have a busy board the updated way is really enough, because you'll surely have a new post shortly after adding a new moderator.
just on not so busy boards the cache can be too old for you
For the hackinstructions i prefer the easier way, but of course you can add one query to the add moderator function to always update the cahce afterwards: [sql]DELETE FROM cache_forumhome[/sql]
As i say it's not needed, you have to modify other files, too, but you can do, without any negative aspects except of little more work
hmm, you don't have the zlib installed on your host have you?
if you have not, the whole html is saved uncompressed in the db, which will blow the table very fast. especiall when there are much users online.
try to contact your host to install zlib and allow more memory