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 nuno
Chen already said one query is slower, however, this only occurs when you have a considerable amount of PM's stored.
So, i think your assumption is not correct.
It is faster for users with few pm's.
where's the threshold of this considerable amount?
I do like those well scaling solutions more than those with unneccesary performance breaks.
I just wanted to say that it's not always good to run less queries than others do.
Maybe someone could figure out how many PMs are needed to make this one query slower than the original three.
My Database stores 1.3 million PMs and as I said before, the three queries are faster by factor 6 - 8
Originally posted by pwr_sneak
where's the threshold of this considerable amount?
I do like those well scaling solutions more than those with unneccesary performance breaks.
I just wanted to say that it's not always good to run less queries than others do.
Maybe someone could figure out how many PMs are needed to make this one query slower than the original three.
My Database stores 1.3 million PMs and as I said before, the three queries are faster by factor 6 - 8
you are right here, it would be intresing to find out how much pm's are needed to slow down...
in all my tests the one query was faster, but i never had 1,3 million pm's which i think most of the admins won't have....
If you have such a great db and board the optimization is to diasble pm-queries at all...
Originally posted by Xenon If you have such a great db and board the optimization is to diasble pm-queries at all...
the 3 pm-queries on index.php run 0.0068 seconds on my servers. no matter how huge the privatemessage table is since mysql doesn't have to read anything from disk or crawl through big B-Trees.
Xenon, seems that this hack doesnt work with version 2.3.0
I installed it and then the forums homepage doesnt load, please have a look at it, the hack is great and I want to use it on my 2.3.0 board
I've nearly completely recoded it up from ground, so you do better in completly uninstall version1 and install version2
the new version doesn't use the table cache_forumhome anymore, so you could DROP it from your database.
at least, no single caching is used anymore (except from moderatorlist caching)
The hack is now just an optimization of the forumhome queries.
on more frequented boards this will help much better than the old version.
also the pm query section has been optimized, so it would work much faster on large DB's than the old one..
Optimizing Forumhome Details »»
About Developer
No support by the author.
02-02-2003, 06:25 PM
