♥ecartz Posted September 19, 2009 Posted September 19, 2009 I take it that your site is an MS2 site? Try updating includes/modules/new_products.php to use the RC2a version. It should use only one query to get all the products, where the MS2 version used two for each product (plus one to get all the products). Always back up before making changes.
oringmonkey Posted September 19, 2009 Author Posted September 19, 2009 Just tried your suggestion. Changed it from 72 queries to 57 queries. Still taking 5.1 seconds to load up. I called up GoDaddy and they acknowledged that this issue has been reported so I think I'm not the only one with this issue suddenly. I'm thinking it might be the database server because both my site, admin, and forums (which is on a different database) are all slowed down, but when I use my ftp, it's still lightning fast. They said hopefully things will be resolved within a day. Kinda makes me feel better knowing that it wasn't something I did because I didn't do anything for the past week hahah.
Jan Zonjee Posted September 19, 2009 Posted September 19, 2009 Still taking 5.1 seconds to load up. If you add up all the time needed for the queries you probably end up way below 0.5 seconds. This is beyond what you can do about it IMHO.
oringmonkey Posted September 19, 2009 Author Posted September 19, 2009 Yeah, actually I did add it all up and it was a really low number. I'm now sure that it has to do with my host. I just received a response from them: Dear Sir/Madam, After reviewing your account it appears that the server associated with your hosting account is experiencing issues with load times, however, when I access your site I was not able to replicate any abnormal slowness at this time. We are currently working to get this issue resolved as soon as possible. Unfortunately, we are unable to give a specific time frame for this resolution. We appreciate your patience and understanding in this matter and we apologize for any inconvenience. Please let us know if we can assist you in any other way.
Jan Zonjee Posted September 19, 2009 Posted September 19, 2009 Yeah, actually I did add it all up and it was a really low number. I'm now sure that it has to do with my host. Well, they actually admit it in their email. Looks like this is not an issue with MySQL (although reducing of queries seemed to help but that might be co-incidence) but with other server software (PHP? Apache?).
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.