PPCGeeks

PPCGeeks (http://forum.ppcgeeks.com/index.php)
-   Site News & Announcements (http://forum.ppcgeeks.com/forumdisplay.php?f=20)
-   -   Random 2-3+ second page loads (http://forum.ppcgeeks.com/showthread.php?t=107951)

mindfrost82 03-02-2010 11:16 PM

Re: Random 2-3+ second page loads
 
How does this seem since this afternoon? So far it seems much better for me.

GirlGoneGeek 03-02-2010 11:37 PM

Re: Random 2-3+ second page loads
 
as of now, much much better! Thanks :)

mindfrost82 03-03-2010 12:29 PM

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.

rainfreak 03-03-2010 01:18 PM

Re: Random 2-3+ second page loads
 
Quote:

Originally Posted by mindfrost82 (Post 1603750)
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.

Carla 03-03-2010 08:45 PM

Re: Random 2-3+ second page loads
 
You know that is what I was thinking it was :p

MordyT 03-03-2010 09:05 PM

Wirelessly posted (HTC Touch Pro2: Opera/9.5 (Microsoft Windows; PPC; Opera Mobi/17992; U; en))

lets not all take credit for frostys hard ork all at once. :)


All times are GMT -4. The time now is 06:49 AM.

Powered by vBulletin® ©2000 - 2025, Jelsoft Enterprises Ltd.
©2012 - PPCGeeks.com


Content Relevant URLs by vBSEO 3.6.0