SMF Support > Server Performance and Configuration
Board running slooooooooooow!!
[Unknown]:
Could be the location mod, I suppose. That could be the Who's online query, now that I look at it again...
What if you disable who's online temporarily?
By the way, if you see something going off like that, at 50+ seconds with everything else locked, I suggest you KILL it.
-[Unknown]
mystik:
well i removed it and it the board seems to be moving a Tad faster.....
are there any other tips u can give me that may help speed up generation time?
[Unknown]:
Your forum is rather slow... but, 200,000 posts and 41 people online shouldn't cause that :P.
Are you on a shared or dedicated server? Do you have "check avatar size every time it's displayed" disabled? (you should have it off!)
I'm getting page load times in the range of 14/5 seconds; that really isn't acceptable. Are any other queries ever holding things up longer than a second? Except for searching, no queries should run that long.
-[Unknown]
mystik:
i agree....!!! :(
unfortunately we are on a shared box however theres not much other activity going on in MYSQL at the same time.....i think my site has the most Mysql activity on that box daily..
also...we dont have that avatar setting on...
heres another shot....much less queries at any time than before....
[Unknown]:
That's still taking too long.
How many posts do you have showing per page? Does it help if you make the topics and attachments tables InnoDB?
How many rows are in attachments and log_online?
Can you tell me the output of this query:
SHOW CREATE TABLE wheels_forumlog_online;
-[Unknown]
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version