Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Optimizing Forumhome Details »
Optimizing Forumhome
Mod Version: 1.00, by Xenon (Member) Xenon is offline
Developer Last Online: Jul 2018 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (2 votes - 5.00 average) Installs: 94
Released: 20 Dec 2002 Last Update: Never Downloads: 16
Not Supported  

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

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 20 Dec 2002, 22:37
NTLDR's Avatar
NTLDR NTLDR is offline
 
Join Date: Apr 2002
Real name: Lee Botley, BSc (Hons)
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

Last edited by NTLDR; 21 Dec 2002 at 19:33.
Reply With Quote
  #3  
Old 20 Dec 2002, 22:38
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser

i hope i'll get good results by you NTLDR
Reply With Quote
  #4  
Old 20 Dec 2002, 22:44
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Yea i'll test this one out - sounds awesome :P
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #5  
Old 20 Dec 2002, 22:57
Chris M's Avatar
Chris M Chris M is offline
 
Join Date: Dec 2001
Real name: Chris Murphy, BSc
Sounds good

Will install

Satan
Reply With Quote
  #6  
Old 20 Dec 2002, 23:09
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Real name: Julian Muņoz
I'm going to test it for my new site! Thanks Xenon!
__________________
Julian D. Muņoz
Reply With Quote
  #7  
Old 20 Dec 2002, 23:17
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
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
Reply With Quote
  #8  
Old 20 Dec 2002, 23:47
Lanigironu Lanigironu is offline
 
Join Date: Mar 2002
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?
Reply With Quote
  #9  
Old 21 Dec 2002, 00:14
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

Also, the code for this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

must be a little different in 2.2.9.
Reply With Quote
  #10  
Old 21 Dec 2002, 00:31
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
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

Last edited by Xenon; 21 Dec 2002 at 00:35.
Reply With Quote
  #11  
Old 21 Dec 2002, 00:34
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
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.
Reply With Quote
  #12  
Old 21 Dec 2002, 00:40
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
of course, because the threadviewpart was a hack wasn't it?

instead of this code:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

use this one:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

so it should work and you have your views again
Reply With Quote
  #13  
Old 21 Dec 2002, 00:49
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
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.
Reply With Quote
  #14  
Old 21 Dec 2002, 01:00
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser


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

Reply With Quote
  #15  
Old 21 Dec 2002, 01:04
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:04.

Layout Options | Width: Wide Color: