Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Reload this Page Page load time?
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 12-18-2008, 12:17 AM
KevinL KevinL is offline
 
Join Date: Apr 2005
Posts: 1,287
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 12-18-2008, 09:56 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
How many queries are on that page? Usually, you should be looking for a 80%/20% PHP/MySQL distribution.
Reply With Quote
  #3  
Old 12-18-2008, 10:58 AM
KevinL KevinL is offline
 
Join Date: Apr 2005
Posts: 1,287
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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 12-18-2008, 11:39 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #5  
Old 12-18-2008, 12:11 PM
KevinL KevinL is offline
 
Join Date: Apr 2005
Posts: 1,287
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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 12-18-2008, 02:27 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
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.
Reply With Quote
  #7  
Old 12-19-2008, 01:32 PM
KevinL KevinL is offline
 
Join Date: Apr 2005
Posts: 1,287
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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 04-16-2009, 02:15 PM
testbot testbot is offline
 
Join Date: Feb 2009
Posts: 373
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
how and where are you getting these stats? i'm trying to troubleshoot slow connection times.
Reply With Quote
  #9  
Old 04-16-2009, 06:51 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
search for "microstats"
Reply With Quote
  #10  
Old 04-16-2009, 07:03 PM
testbot testbot is offline
 
Join Date: Feb 2009
Posts: 373
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
oh, i saw that but it requires you to edit the core and i try to avoid that.

any other options?
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

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
Forum Jump


All times are GMT. The time now is 12:54 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05968 seconds
  • Memory Usage 2,251KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete