Extremely slow loading PHP page help.
Posted: Sun Oct 23, 2011 5:48 pm
Hey gang;
Among the several websites I have, one is called CGSphere.com (http://www.cgsphere.com) and it's been going for some time. It's a gallery website of sorts and a fun, free creative competition. It's always had a very slow load page time on the pages that require loading and displaying various thumbnails, to the point where it's excruciatingly slow and often takes up to 10 seconds to load, or longer. More and more users are complaining about it and I've promised to see if I can improve it.
After some testing, I've come to realize it's most likely the SQL query (or something to do with it) since it's only slow on the front page and the gallery page, the two that display thumbnails. The other ones, are very quick and I believe have limited, or no access to the DB. A couple of friends have suggested the sql query might be the source of the problem.
I thought perhaps its the speed of my server but I have other websites as well on my dedicated root server that also access their own database and their speed is just fine so this proves it's nothing to do with a slow server.
I'm not much of a PHP developer but can manage my way around minor changes and modifications. An associate had previously built the site for me but he's unavailable at this time. I was hoping someone could take a look at it and perhaps shed some light on where they think the problem may lie and, if it's easy enough, I might be able to make the modifications myself (or even better, with their help).
The very slow pages in specific are http://www.cgsphere.com and http://www.cgsphere.com/gallery/
While clicking on any of the other ones results in nice, speedy refreshes.
I really appreciate any help on this. I'm at a loss at this point and require the assistance of professionals.
Thanks,
-Richard
Among the several websites I have, one is called CGSphere.com (http://www.cgsphere.com) and it's been going for some time. It's a gallery website of sorts and a fun, free creative competition. It's always had a very slow load page time on the pages that require loading and displaying various thumbnails, to the point where it's excruciatingly slow and often takes up to 10 seconds to load, or longer. More and more users are complaining about it and I've promised to see if I can improve it.
After some testing, I've come to realize it's most likely the SQL query (or something to do with it) since it's only slow on the front page and the gallery page, the two that display thumbnails. The other ones, are very quick and I believe have limited, or no access to the DB. A couple of friends have suggested the sql query might be the source of the problem.
I thought perhaps its the speed of my server but I have other websites as well on my dedicated root server that also access their own database and their speed is just fine so this proves it's nothing to do with a slow server.
I'm not much of a PHP developer but can manage my way around minor changes and modifications. An associate had previously built the site for me but he's unavailable at this time. I was hoping someone could take a look at it and perhaps shed some light on where they think the problem may lie and, if it's easy enough, I might be able to make the modifications myself (or even better, with their help).
The very slow pages in specific are http://www.cgsphere.com and http://www.cgsphere.com/gallery/
While clicking on any of the other ones results in nice, speedy refreshes.
I really appreciate any help on this. I'm at a loss at this point and require the assistance of professionals.
Thanks,
-Richard