Long Pause Before Pages Load

[SaraiSarai]

For some reason, the past few days my site has been taking very long to load. I am not sure what is going on or what to do. I have tried to optimize my database per GoDaddy's recommendation, but that hasnt helped me. It's not only my zencart website that takes forever to load, but the admin side of my site does the same thing. I dont think its a server issue because my wordpress blog on my site works just fine. Can someone help me please?

www.Sarai-Sarai.com

[stevesh]

Try enabling parse time display in Admin - Configuration - Logging, then:

http://www.zen-cart.com/content.php?...s-numbers-mean

[SaraiSarai]

Try enabling parse time display in Admin - Configuration - Logging, then:

http://www.zen-cart.com/content.php?...s-numbers-mean

Okay i did that, and when i load my home page, it gives me this:

Parse Time: 5.865 - Number of Queries: 125 - Query Time: 3.4699792272491

I have no clue what this means. Am I having a server issue, or is there an issue within my site? Its so strange because i haven't really changed anything in the code, and I started having this issue all of a sudden.

[joejoejoe]

The explanation for parse times can be found here:
https://www.zen-cart.com/content.php...s-numbers-mean

Parse times aside - the whole pause-before-executing is the symptom i was having with my host for the 3-4 months before they admitted their shared server was over-shared. My blog seemed faster because it wasn't executing the ginormous number of queries that my store was. It was worse during peak times when my neighbor was sending out his ############ emails or streaming his XXX videos but mysteriously cleared up after they moved me to a less stressed out server. You might try pestering them to look and see what all they've crammed in there with you.

Edit: I like how I can say XXX videos but can't say Vigh-Agh-Ruh! (####### emails).

[SaraiSarai]

The explanation for parse times can be found here:
https://www.zen-cart.com/content.php...s-numbers-mean

Parse times aside - the whole pause-before-executing is the symptom i was having with my host for the 3-4 months before they admitted their shared server was over-shared. My blog seemed faster because it wasn't executing the ginormous number of queries that my store was. It was worse during peak times when my neighbor was sending out his ############ emails or streaming his XXX videos but mysteriously cleared up after they moved me to a less stressed out server. You might try pestering them to look and see what all they've crammed in there with you.

Edit: I like how I can say XXX videos but can't say Vigh-Agh-Ruh! (####### emails).

LOL! Okay thanks. I read about the parse times but i'm not very good with understanding some of these things.

If it is a server issue I wonder if switching from Linux to Windows server at Godaddy will help me? Im so over GoDaddy and all of their issues :-(

[stevesh]

Switching to a Windows server may well make things worse. My advice would be to follow joejoejoe's lead and demand that GoDaddy move you to a less-crowded server.

[SaraiSarai]

Switching to a Windows server may well make things worse. My advice would be to follow joejoejoe's lead and demand that GoDaddy move you to a less-crowded server.

Thanks a bunch to both of you. I will ask them to do that :-)

[DrByte]

Also, ask them to "profile" your site because it's slow. If the person you talk to doesn't know what that means, tell them to escalate the request to 3rd level support or higher --- someone up higher *will* know what it means.

[SaraiSarai]

Also, ask them to "profile" your site because it's slow. If the person you talk to doesn't know what that means, tell them to escalate the request to 3rd level support or higher --- someone up higher *will* know what it means.

I will ask them to do this as well because I am very confused. They asked me to send them a trace route. After i did, this was their response:

"Thank you for your response. Upon review of your trace route I have found that your connection slows at hop 3 at IP address 71.144.128.132. After researching the issue, it appears that 71.144.128.132 belongs to AT&T Internet Services.

You will need to contact your Internet Service Provider with the results of your trace route for more information regarding this issue. We appreciate your cooperation regarding this matter."


My first problem with this is, if its a issue with my ISP, why am I having trouble with my website only? So, with that being said, i went to my brothers house to visit my site using a totally different ISP. Same issue. I replied to them letting them know this. Not only that, but I checked my Google Analytics and my site had a total of 3 unique visits on Saturday. On Sunday, I had a total of 2. I am losing a large number of potential customers, etc. I haven't seen those numbers since I first launched my site. Their response was:

"In regard to the website latency associated with sarai-sarai.com, fwe have reviewed your hosting account and there are no known issues, at this time, that would cause issues with your website resolution speed. It appears that your network or ISP is having an issue connecting to the DNS information published for your domain. The results of your trace route show that you are timing out before you reach our servers, specifically at hops 4 and 5. However, it appears the time outs are AT&T re-routing the connection. As such, this may be causing the website latency. Additionally, please review http://www.webpagetest.org/result/12...4A1/1/details/, as it appears the coding, scripting or similar specific to sarai-sarai.com - boutique/ is generating the latency. As such, we would recommend reviewing the coding and scripting in relation to the following information."

Then they suggested a number of things to do including GZip compression, reducing image sizes, etc. I have not messed with the coding, Scripting, CSS of my site in a while. It was working perfectly fine. For me to have this issue all of a sudden, i dont understand why it would be the coding if nothing has changed there.

[DrByte]

It's good that they investigated those things. Those are some of the first basic things that need to be checked.

The first about latency in your own traceroute is, as you said, somewhat moot since the problems you have are isolated to your own site alone. Notwithstanding that your ISP may have "issues", the problem may have nothing to do with that. The result is not a deciding factor. It's just additional information.

The second about "a scripting issue" suggests that it's something wrong on your site. Duh. Exactly. And that could be something on the server, or something in the software you've added to your site (to "be" your site). Hence the need for some profiling to find out where the specific bottlenecks are.

The parse times you mentioned reveal that the slowness is in the database activity ... so I wouldn't be surprised if their profiling tells you there's something wrong with either their database connection, or server load, or perhaps just a rogue query. More info needed. Hence the profiling request being the next step.