Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 Mar 2003, 15:58
jacobi's Avatar
jacobi jacobi is offline
 
Join Date: Jan 2003
Real name: Adam Jacobi
Question About vBulletin.org

Hello,

I'm a relative newbie, in my third month as a vBulletin user (yes, I literally rang in the New Year with the license purchase!)

In that time, I've really come to admire the innovative and supportive community here.

Recently, my Web hosting company decided to put query limitations on its MySQL to benefit all of the users in a least-common denominator fashion. While this is a minor inconvenience compared to the great service I have had with this host to date, I would like a way to measure the queries on the board, much as vBulletin.org has at the bottom of all of its pages.

I tried searching for a hack that does this, and I couldn't find one.

While I'm at it, is there a place that documents the various hacks installed at this site (like the front/portal page, or the login/welcome at the top of the board, etc.?

Thank you!
Reply With Quote
  #2  
Old 13 Mar 2003, 16:05
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
sorry but even me doesn't know all hacks which are installed here.

the one you've asked for is the microstats hack by TECK.

once we upgrade to vb3 i hope we will make a list where we add all hacks made to vb.org, at least if we use one of the released
Reply With Quote
  #3  
Old 15 Mar 2003, 15:12
lynda's Avatar
lynda lynda is offline
 
Join Date: Nov 2001
jacobi, I'm pretty sure the hack you're looking for is this:

http://www.vbulletin.org/forum/showt...threadid=35811

It has been very helpful to me in measuring queries per page.

I also find it's useful to turn debug mode on (add $debug=1 to the config.php) and then add explain=1 to the end of a url - that will display all the queries running.

Reply With Quote
  #4  
Old 15 Mar 2003, 15:47
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Also Xenon has a hack in his profile which reduces queries on your main forums index

- miSt
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #5  
Old 16 Mar 2003, 13:06
jacobi's Avatar
jacobi jacobi is offline
 
Join Date: Jan 2003
Real name: Adam Jacobi
Cool Thank you!

Mist, Lynda, Xenon (and Teck) - you have made my life so much easier and I look forward to implementing all of your suggestions. I've already installed the MicroStats hack, and I can see what functions are a drag on the queries.

Thanks again!
Reply With Quote
  #6  
Old 16 Mar 2003, 13:13
N9ne N9ne is offline
 
Join Date: Feb 2002
I can definitely recommend Xenon's forumhome optimization hack, works wonders .
__________________
[Signature Goes Here]
Reply With Quote
  #7  
Old 16 Mar 2003, 13:50
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Your Welcome jacobi

- miSt
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
Reply



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

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 07:45.

Layout Options | Width: Wide Color: