View Single Post
  #33 (permalink)  
Old 03-03-2010, 12:29 PM
mindfrost82's Avatar
mindfrost82
Retired Staff
Offline
Threadstarter
Location: Illinois
 
Join Date: Sep 2006
Posts: 4,474
Reputation: 42486
mindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation levelmindfrost82 can't get a higher reputation level
Mentioned: 7 Post(s)
Tagged: 1 Thread(s)
Send a message via Skype™ to mindfrost82
Re: Random 2-3+ second page loads

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.
__________________
TeckLyfe.com
At&t iPhone 8 Plus
Reply With Quote
This post has been thanked 1 times.