Product Pages Painfully Slow

[craftideasweekly]

I am using 1.3.9 with Easy Populate, an seo module, a query cache add on, and the apparel boutique template.
I have recently begun uploading products via Easy Populate and have noticed that while the home and category pages load fine, the individual product pages load extremely slow (like they are going to time out for people slow.) Even on a page with no product image and very little going on (like this one: http://craftsupply.craftideasweekly....12-p-2581.html) it takes FOREVER to load.

I installed a query caching code hoping it would improve the issue...I suppose it did a little...but the project pages are still slow.

Any advice on how to fix this? Looking around on the forums, it seems this might be a database load issue. I am considering installing the magneti cone Zen Cart.Performanc e.module but don't want to install anything else if it is for nothing. I am also considering installing an image handler to improve overall site load but I am not sure it will help this issue.

Where should I go from here?

Thanks!
Molly

[nigelt74]

your category page has loads more images so a page like this should be slower
http://craftsupply.craftideasweekly....age=2&sort=20a
but instead its snappy

That points to something on the product page, the only thing i can see different to normal is your social network script have you tried removing it to see if that makes a difference?

If you are using forefox you can analyse where the blockage/slowdown is using pagespeed or yslow

[mprough]

Some food for thought...


Have a look at these ping times ... Quite slow

Ping 173.201.98.236

[craftsupply.craftideasweekly.com]

Round trip time to 173.201.98.236: 30 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 30 ms
Round trip time to 173.201.98.236: 29 ms
Round trip time to 173.201.98.236: 29 ms

Average time over 10 pings: 29.2 ms

The page you supplied (http://craftsupply.craftideasweekly....12-p-2581.html) has a missing, but desperately trying to load product image.

However, with a Google PageSpeed score of 80/100 I would have to start thinking hosting issues. Then I pull your DNS and see where you are hosted and have to look no further... You need to get a decent webhost.

~Melanie

[craftideasweekly]

I had previously removed the social media code to see if it made a difference and also loaded the entire site in the default Zen template to rule out any template/design issues. I posted a product detail page without an image simply as a test but all of the product detail pages have the same slow load time.

Could an error in the database cause this issue? It seems to weird to me that it ONLY happens on the product detail pages when other pages are serving much heavier content at 5x the speed.

I use GoDaddy 4GH with unlimited bandwidth and 150,000GB disk space and am not even close to reaching that usage. If it were an issue with the host, would I not have slowness across the whole site?

Is it possible one of the tables in the DB is having an issue? (I'm thinking possibly a field only used by product detail pages)

I really appreciate the help!

[mprough]

The size of your plan... allowed disk and bandwidth have nothing to do with the server load. These servers are loaded... and loaded and loaded some more. They provide quantity not quality.

Want to check for yourself?

Go to your admin Configuration >> Logging >> and set Display The Page Parse Time to TRUE

Now compare it to ours for example (It will be in the footer)

http://pro-webs.net/store/

~Melanie

[craftideasweekly]

The size of your plan... allowed disk and bandwidth have nothing to do with the server load. These servers are loaded... and loaded and loaded some more. They provide quantity not quality.

Want to check for yourself?

Go to your admin Configuration >> Logging >> and set Display The Page Parse Time to TRUE

Now compare it to ours for example (It will be in the footer)

http://pro-webs.net/store/

~Melanie

Hi Melanie,
I believe you - just want to make sure I understand what is causing what. I have read that GoDaddy has a bad rep forloaded servers. But why would it cause slow loading on ONLY the product detail pages? That is what I am trying to understand...

I am open to looking at new hosts but need to make sure that is really causing the extreme slowness on only one section of my site.

Your site is great and super speedy (you guys host it?)

Thanks again,
Molly

[DrByte]

... I would have to start thinking hosting issues. Then I pull your DNS and see where you are hosted and have to look no further... You need to get a decent webhost.

~Melanie

Agreed.

[craftideasweekly]

Just found the page that executes all the DB queries to render the product pages...wow! Now I see why this requires a better hosting environment. Makes sense now why these pages are having the most trouble.

Would upgrading to Virtual Private Server or a Dedicated Server with my current host (GoDaddy) be an option? I am nervous to switch hosts...my learning curve, uptime, support...so much that could go wrong! (plus I have purchased hosting for the next year already with GoDaddy which they may be able to transfer some kind of credit to a new plan.) What do you think?

Thanks so much,
Molly

[DrByte]

Would upgrading to Virtual Private Server or a Dedicated Server with my current host (GoDaddy) be an option? I am nervous to switch hosts...

Switching to another unnecessarily expensive plan with your current host involves the same steps technically as would a move to another host. You still have to switch *servers* in either case.
https://www.zen-cart.com/tutorials/i...hp?article=100
Better to be putting the effort into being with a more reliable host than to waste it on the existing one.

[ultrageoff]

Hi Molly

I'm no genius, but I have had similar problems to the one you describe and seen a radical, immediate improvement without changing hosts. In fact, I'm using just a tenth of a very cheap hosting package. I was occasionally getting problems with the

1062 Duplicate entry 'zc_56bef17b17fbeb6627441de26659411d' for key 1
in:
[db_cache table]

error message coming up far too often. When the site was 'working' without that error displaying, it was painfully slow and the Product pages were often particularly slow (30 seconds...). There are theories as to why this 1062 error surfaces, but they all seem linked to having a very slow response (perhaps a second query is coming in before the first one has returned - which sort of implies that the queries are not being returned quickly?). I'm running 1.3.9h on what is a 11S hosting server.
Solution? I went back to running with SQL Cache Method: None.

See http://www.zen-cart.com/forum/showthread.php?t=69700

No cache, so no duplicated items in the cache.
There is more than one piece of advice out there advising caching; I'd definitely treat it with caution. Perhaps I was running some form of corrupted cache, but perhaps I wasn't. My site is absolutely fine now.