I have been having random issues with the front page loading slow. It's only the front (portal) page that will do this.
Using debug I found this was consistently loading slow:
SELECT m.ID_MEMBER, COUNT(m.ID_MEMBER) as postCount
FROM (smf_messages AS m, smf_topics AS t, smf_boards AS b)
WHERE m.posterTime > 1233993600
AND t.ID_TOPIC = m.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD AND b.ID_BOARD != 22
GROUP BY m.ID_MEMBER
ORDER BY postCount DESC LIMIT 10
in /xxx/xxx/ksguild.org/Sources/Load.php(1753) : eval()'d code(52) : eval()'d code line 15, which took 11.70364499 seconds.
The board it references is the recycle board (which with the ! its actually not that board?). Which I emptied after noticing this anyways. The front page will still load slow at times. As you see from this one it took 11 sec for the one entry. All others are .000n seconds.
This began about a month ago. Nothing was changed or edited on the site when it started.
Any ideas why this would be so slow?
Hi Omniverse, if you follow this it will make it easier to help:
Please read the Posting Guidelines.html (http://www.tinyportal.net/index.php/topic,581)
If it's your Perry site that's in question try disabling your navigation add-on panel... it seems to take a long time to load up for me.
I would start by eliminating one block at a time to see if any particular one is causing you extra load time. It could be due to the 2nd center block because it's loading all the content in each tab before loading the frontpage.
QuoteThe board it references is the recycle board (which with the ! its actually not that board?)
So that's every board except the recycle board then ;)
Gerry
It's the Kindred site, not the Perry one.
Other than not including a link, what did I not follow on the posting guide? I didn't think a link was relevant since this happens only to those logged in, not to guests. So clicking a link won't show you its slow.
What I was hoping for was that someone had a clue as too what that call is a reference to. Seems like maybe recent topics? I just use the TP default one.
I have attempted going through and shutting off blocks, but I still get the intermittent slow downs no matter what blocks are up it seems. This began happening randomly, nothing had been changed on the site for months.
Looks like an SMF query, but I'm not 100% sure on that. It looks like its counting posts from the messages table for stats or something. I'm not sure what is causing it. My only suggestion would be to disable all the TP stuff you have possible. All blocks, all articles and see if it still happens. If it does, then I would even go as far as uninstalling TP and see if you still get the slowness. This will help you rule out TP.