MyBB Community Forums

Full Version: Forum is very laggy?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
That is definitely your hosting mate, just trust me... 9 queries in 6.3 seconds is stupidly slow. It's like an olympic athlete running the 100 metres in 6 minutes...
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 	0.28294396400452 seconds 	No. DB Queries: 	9
PHP Processing Time: 	0.2694886 seconds (95.24%) 	DB Processing Time: 	0.0134554 seconds (4.76%)
Extensions Used: 	mysqli, xml 	Global.php Processing Time: 	0.2169080 seconds
PHP Version: 	5.2.17 	Server Load: 	Unknown
GZip Encoding Status: 	Enabled 	No. Templates Used: 	43 (44 Cached / 0 Manually Loaded)
Memory Usage: 	3.75 MB (3932160 bytes) 	Memory Limit: 	32M
Database Connections (1 Total)
[READ] [email protected] (Connected in 0s)

Database Queries (9 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.00046515464782715

#2 - Select Query
SELECT title,cache FROM mybb_cfaforumdatacache
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_cfaforumdatacache 	ALL 					30 	
Query Time: 0.0041379928588867

#3 - Select Query
SELECT * FROM mybb_cfaforumsessions WHERE sid='bbae0786be4097e97b6585b6307a3035' AND ip='24.175.191.38' LIMIT 1
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_cfaforumsessions 	const 	PRIMARY,ip 	PRIMARY 	98 	const 	1 	
Query Time: 0.00069212913513184

#4 - Select Query
SELECT u.*, f.* FROM mybb_cfaforumusers u LEFT JOIN mybb_cfaforumuserfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
u 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
f 	const 	PRIMARY 	PRIMARY 	4 	const 	0 	unique row not found
Query Time: 0.001121997833252

#5 - Write Query
UPDATE mybb_cfaforumsessions SET `uid`='1', `time`='1369105262', `location`='/forum/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.2; WOW64; rv:21.0) Gecko/20100101 Firefox/21.0', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='bbae0786be4097e97b6585b6307a3035' LIMIT 1
Query Time: 0.00070309638977051

#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_cfaforumthemes WHERE tid='5' LIMIT 1
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_cfaforumthemes 	const 	PRIMARY 	PRIMARY 	2 	const 	1 	
Query Time: 0.00085306167602539

#7 - Select Query
SELECT title,template FROM mybb_cfaforumtemplates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission') AND sid IN ('-2','-1','4') ORDER BY sid ASC
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_cfaforumtemplates 	ALL 					640 	Using where; Using filesort
Query Time: 0.0014729499816895

#8 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_cfaforumsessions s LEFT JOIN mybb_cfaforumusers u ON (s.uid=u.uid) WHERE s.time>'1369104362' ORDER BY u.username ASC, s.time DESC
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
s 	range 	time 	time 	8 		6 	Using where; Using temporary; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	Robmeister89.s.uid 	1 	
Query Time: 0.0011200904846191

#9 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_cfaforumforums f LEFT JOIN mybb_cfaforumforumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
f 	ALL 					17 	Using where; Using filesort
fr 	eq_ref 	fid 	fid 	8 	Robmeister89.f.fid,const 	1 	
Query Time: 0.00089693069458008

Template Statistics
Templates Used (Loaded for this Page) - 43 Total
global_boardclosed_warning, global_pm_alert, index, header_welcomeblock_member, header_welcomeblock_member_moderator, header_welcomeblock_member_admin, redirect, gobutton, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, global_unreadreports, global_pending_joinrequests, index_loginform, index_whosonline, index_stats, index_birthdays_birthday, forumbit_moderators, index_birthdays, index_logoutlink, error_nopermission, error_nopermission_loggedin, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, error_inline, global_bannedwarning, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost

Templates Requiring Additional Calls (Not Cached at Startup) - 0 Total

(2013-05-21, 02:58 AM)Grumpy Wrote: [ -> ]That is definitely your hosting mate, just trust me... 9 queries in 6.3 seconds is stupidly slow. It's like an olympic athlete running the 100 metres in 6 minutes...

So why doesn't the website take forever to load then?

Just tested the site...

http://tools.pingdom.com/fpt/#!/cp3n0giH...tball.com/
(FASTER) then 74%


http://tools.pingdom.com/fpt/#!/v84JzD4S....com/forum
(SLOWER) then 70%

I'm not sure what to do here... why is the forum loading slow but the not website itself? I'm not trying to sit here and blame mybb, just want to know what to do to improve the situation.

And now the forum won't even load for me...
Your forum can not be opened.

the link you gave is incorrect. should http://cfa-football.com/forum.html
/forum.html leads to my site with the forum embedded
/forum leads to the forum itself

The forum does open.. when it wants to. there is times where it loads in .2 seconds, as you can read in that code, and there is times where it takes 12 seconds.
Have you tried disabling your plugins to see if one of those is causing issues?
The website itself is slow like the forum, and obviously the forum is slower because it's not static HTML like your homepage. There's no queries involved there.
I removed two of my plugins and it looks like its loading a bit faster. I'm still having some members complain that it is not loading at all.

Also, why aren't the images showing up? Is there any way that the update to 1.6.10 messed those up? I can't view any issues on the main forum.

Disregard.. fixed the images problem. The update must have changed my template image directory.. its fixed.
^ do you have novus theme images uploaded at correct folder(s) ?
some image links are pointing to themes/novus-dusk/ folder and some are pointing to images/novus-dusk/ folder.
Whoops... not sure what happened to those theme images but they are gone. They're back now and its fixed.
Pages: 1 2