Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Dec 2008, 02:17
KevinL KevinL is offline
 
Join Date: Apr 2005
Page load time?

I have installed xcache and memcached. My server loads have gone down but my page load time went from .5 high times .2 low times now to 1.4 all the time.

On my forumhome 35.63% PHP - 64.37% MySQL | 0.08 : 0.08 : 0.11 | those are my stats. It goes down slightly on other pages...

I don't know whats going on now

Does anyone have any ideas?
Reply With Quote
  #2  
Old 18 Dec 2008, 11:56
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
How many queries are on that page? Usually, you should be looking for a 80%/20% PHP/MySQL distribution.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #3  
Old 18 Dec 2008, 12:58
KevinL KevinL is offline
 
Join Date: Apr 2005
On forumhome I have 22 queries. On showthread my stats are Page generated in 0.41299 seconds (66.84% PHP - 33.16% MySQL) with 18 queries everything is the same before installing xcache and memcahced. It seems like the forum was running faster before.

How would I go about getting that 80%/20%? You look at a site like Ayyas that looks like it has no MySQL queries....how do they do that? Is there a way to cache the queries? ...which is what I thought memcached was doing?

Thanks for the reply
Reply With Quote
  #4  
Old 18 Dec 2008, 13:39
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
22 queries is way too much, even if they are relatively quick ones. You most likely have heaps of modifications installed, leading to piles of queries. Install modifications sparingly. Install those that you need.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 18 Dec 2008, 14:11
KevinL KevinL is offline
 
Join Date: Apr 2005
Well I got it down to 16 on forumhome but that still has my stats at Page generated in 0.38854 seconds (20.41% PHP - 79.59% MySQL) with 16 queries

I'm mostly concerned about that 20/79...the page load has decreased some but I don't have that many people online right now.

Also I really don't have that many mods installed...
Reply With Quote
  #6  
Old 18 Dec 2008, 16:27
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
Originally Posted by KevinL View Post
Well I got it down to 16 on forumhome but that still has my stats at Page generated in 0.38854 seconds (20.41% PHP - 79.59% MySQL) with 16 queries

I'm mostly concerned about that 20/79...the page load has decreased some but I don't have that many people online right now.

Also I really don't have that many mods installed...
Is your server optimized?

Try posting over at vbulletin.com in the Server configuration section: http://www.vbulletin.com/forum/forumdisplay.php?f=14

They're pretty good with getting your server optimized.
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #7  
Old 19 Dec 2008, 15:32
KevinL KevinL is offline
 
Join Date: Apr 2005
Thank you for your replies guys.

I didn't make a post over there but I did read a bunch of the posts and for the most part a lot of the suggestions were the same so I made the changes accordingly and things seem to be much snappier.
Reply With Quote
  #8  
Old 16 Apr 2009, 16:15
testbot testbot is offline
 
Join Date: Feb 2009
how and where are you getting these stats? i'm trying to troubleshoot slow connection times.
Reply With Quote
  #9  
Old 16 Apr 2009, 20:51
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
search for "microstats"
Reply With Quote
  #10  
Old 16 Apr 2009, 21:03
testbot testbot is offline
 
Join Date: Feb 2009
oh, i saw that but it requires you to edit the core and i try to avoid that.

any other options?
Reply With Quote
  #11  
Old 16 Apr 2009, 21:58
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
If you want the stats, then you need to install it.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
vbMicroStats: page load time, queries, GZIP and PHP version TECK vBulletin 2.x Full Releases 942 15 Jan 2005 00:43



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 12:39.

Layout Options | Width: Wide Color: