![]() |
|
Mod Options |
![]() |
|||||||||
This modification is in the archives.
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.... Download Now Only licensed members can download files, Click Here for more information. Show Your Support
No members have liked this post.
|
Comments |
#2
|
||||
|
||||
Thanks for releasing Xenon, I'm going to be sure to test this one
![]()
__________________
Lee Botley, BSc (Hons) - vBulletin.org Moderator http://www.thesistersthree.com/lee/sigs/signature.ts3 The Sisters Three Charmed Discussion Forums WinterDir .:. vBindex v2.1 for vB2 .:. vBindex v3.0.0 RC5 for vB3 No members have liked this post.
Last edited by NTLDR; 21 Dec 2002 at 19:33. |
#3
|
||||
|
||||
![]() i hope i'll get good results by you NTLDR ![]() No members have liked this post.
|
#4
|
||||
|
||||
Yea i'll test this one out - sounds awesome :P
__________________
Dean Clatworthy - Web Developer/Designer No members have liked this post.
|
#5
|
||||
|
||||
Sounds good
![]() Will install ![]() Satan No members have liked this post.
|
#6
|
||||
|
||||
I'm going to test it for my new site! Thanks Xenon!
__________________
Julian D. Muņoz No members have liked this post.
|
#7
|
||||
|
||||
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 ![]() No members have liked this post.
|
#8
|
|||
|
|||
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? No members have liked this post.
|
#9
|
||||||||
|
||||||||
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:
to the query you have to make one less query if we are using this? Also, the code for this:
must be a little different in 2.2.9. ![]() No members have liked this post.
|
#10
|
||||
|
||||
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?
But the additional queries are very fast from what i know compared to the others ![]() No members have liked this post.
Last edited by Xenon; 21 Dec 2002 at 00:35. |
#11
|
||||
|
||||
I don't want it changed if it can be incorporate it into what you already have. It's just that i don't have any threadviews anymore.
![]() I haven't changed anything there (that I can recall). Must be an extra space or something in my file. ![]() No members have liked this post.
|
#12
|
||||||||
|
||||||||
of course, because the threadviewpart was a hack wasn't it?
![]() instead of this code:
use this one:
so it should work and you have your views again ![]() No members have liked this post.
|
#13
|
||||
|
||||
Thank you, sir. And I'm still at 17 queries. You are the Man!
![]() I need to ask, though, is it normal to have this hack add 2 queries until the refresh? I mean, it is supposed to do that, right? By the way, the threadviews was more of a line of code I got from Chen than a hack. ![]() No members have liked this post.
|
#14
|
||||
|
||||
![]() yes it is normal ![]() as said above the two extra queries are fast one's but i can't exactly say the performance power, that's why it's here in beta ![]() ![]() No members have liked this post.
|
#15
|
||||
|
||||
Ok, well, I have noticed the page loads a lot quicker and smoother. So, it must be doing something. But, then, my board doesn't have very many users either, so I can't tell on the server load part of it. Although my server load stats in Microstats are showing 0.09, 0.05, 0.09 right now, if that means anything at all.
![]() No members have liked this post.
|
![]() |
«
Previous Mod
|
Next Mod
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Mod Options | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 20:11.