Thread: Random 2-3+ second page loads
View Single Post
  #34 (permalink)  
Old 03-03-2010, 01:18 PM
rainfreak's Avatar
rainfreak
Gettin' Freaky With It
Offline
Location: Toledo, OH
  
Join Date: Jan 2008
Posts: 12,934
Reputation: 9792
rainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the communityrainfreak is a trusted member of the community
Mentioned: 9 Post(s)
Tagged: 0 Thread(s)
Send a message via AIM to rainfreak
Re: Random 2-3+ second page loads
Quote:
Originally Posted by mindfrost82 View Post
After about a month and a half I *think* I have finally figured this out!!!!!!!

After trying to troubleshoot our webserver, PHP, and everything else under the moon, it came down to a slow MySQL query.

It all boiled down to the Member List page. We had it so that avatars showed up on that page (which I think is the default for vBulletin). Due to how many members we have, this caused a slow query to the database every time someone accessed that list.

So, I disabled avatars on that page and also made it so that only users with >1 post would show up (to cut down on the number of users in the query).

We've been going for about 5 minutes without a slow query now, so hopefully that was it.

Nice job! It always ends up being the least likely solution, or the one that we never thought of, that brings us out of the dark.
__________________
"I remember, way back in the day, this site was hoppin' with members, posts, and some great development."
Reply With Quote