Random 2-3+ second page loads

[mindfrost82]

How does this seem since this afternoon? So far it seems much better for me.

[GirlGoneGeek]

as of now, much much better! Thanks

[mindfrost82]

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]

Originally Posted by mindfrost82

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]

You know that is what I was thinking it was

[MordyT]

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.