Help with parse times?

07 Aug 2012, 10:18

#1

Zen Follower

Join Date:: Dec 2011
Posts:: 287
Plugin Contributions:: 0

Help with parse times?

Hey, I have very very very long loading times on some of my pages, there are a huge number of queries that are executed and I was hoping I could get some info on what Is causing it.

Product listing: Parse Time: 12.032 - Number of Queries: 3108 - Query Time: 9.6986321118469
Product listing: Parse Time: 35.308 - Number of Queries: 4116 - Query Time: 29.818843496048

Is it just because of the large large amount of querys?

Here is an example of one of the pages:

http://kitchenwarehouseltd.com/products/units/high-gloss/aubergine-units

07 Aug 2012, 10:23

#2

barricades

Inactive

Join Date:: May 2007
Posts:: 150
Plugin Contributions:: 0

Re: Help with parse times?

I see what you mean it takes a long time to load! You do have over 100 products on that page and each product has to return a load of different queries and all those images as well. Plus the big hover images seem to load really quick, are they all preloading?

I'd say it's all contributing to the long page load

07 Aug 2012, 10:43

#3

gilby

Totally Zenned

Join Date:: Aug 2005
Posts:: 1,816
Plugin Contributions:: 0

Re: Help with parse times?

Looks like an overloaded host issue, Who is your host?

btw: You have lots of errors
including encoding issues, charset=iso-8859-1 and charset="utf-8"

07 Aug 2012, 11:27

#4

dannyvarley

Zen Follower

Join Date:: Dec 2011
Posts:: 287
Plugin Contributions:: 0

Re: Help with parse times?

I had an idea that it was the host, Godaddy is the current host but Ive heard so so so many horror stories and how they oversell there servers. I suppose its time for a switch? Can anyone recommend a good host?

Also, I know there will be a lot of errors, This is my very first time making a zen-cart site. I will have to try and fix what I can. :(

07 Aug 2012, 19:48

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Help with parse times?

You can see that the majority of the overall time is consumed in the query time. This means that the database engine isn't able to keep up. And frankly those are actually very low numbers of queries and should not take that long to execute.
I've worked with many ZC sites having 10 times that many queries running in under a second.

Related articles:
http://www.zen-cart.com/content.php?145-what-do-the-page-parse-times-and-query-counts-numbers-mean
http://www.zen-cart.com/content.php?63-how-do-i-speed-up-my-site

08 Aug 2012, 08:30

#6

dannyvarley

Zen Follower

Join Date:: Dec 2011
Posts:: 287
Plugin Contributions:: 0

Re: Help with parse times?

So your advice would also to be get a better host?

08 Aug 2012, 14:48

#7

dannyvarley

Zen Follower

Join Date:: Dec 2011
Posts:: 287
Plugin Contributions:: 0

Re: Help with parse times?

I just did a Reverse IP Lookup as this tells me how many other sites are hosted on the same server (I think) and my shared hosting IP said there was another 5180 sites loaded onto the same server.

This seems a huge amount and I think its time for a switch!

17 Aug 2012, 06:25

#8

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Help with parse times?

How's the performance now?

24 Aug 2012, 13:09

#9

rmsimp

New Zenner

Join Date:: Feb 2011
Posts:: 14
Plugin Contributions:: 0

Re: Help with parse times?

I am having a similar problem with parse times. I was using GoDaddy and getting parse times of 58-60 sec. They could not or would not help me I moved to hostgator and they are great. I still have long parse times 18-20 sec. I have upgraded to V1.5 and took all graphics off site and am putting back optimized graphics. Can anyone suggest where the bottleneck might be now. the site is conniesbookshelf.com

27 Aug 2012, 18:14

#10

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Help with parse times?

RMsimp:
I am having a similar problem with parse times. I was using GoDaddy and getting parse times of 58-60 sec. They could not or would not help me I moved to hostgator and they are great. I still have long parse times 18-20 sec. I have upgraded to V1.5 and took all graphics off site and am putting back optimized graphics. Can anyone suggest where the bottleneck might be now. the site is conniesbookshelf.com

Can you confirm what addons you're using on your site?

27 Aug 2012, 23:03

#11

rmsimp

New Zenner

Join Date:: Feb 2011
Posts:: 14
Plugin Contributions:: 0

Re: Help with parse times?

I am using checkout by amazon, paypal, the bookshelf template, and using product type book, and thats it. I am wondering if when they were adding products they could have put something in database wrong. This seemed to come on all at once but they don't know exactly when.

28 Aug 2012, 05:35

#12

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Help with parse times?

I suspect that the indexes on the tables added by your "book" addon are at fault.

Perhaps try running the following SQL statements via phpMyAdmin:

alter table book_authors add index ba_name (book_authors_id,language_ida,book_authors_name,book_authors_nickname);
alter table book_authors_info add index bai_id (book_authors_id,language_id);
alter table books_to_authors add index bta_map (book_authors_id,language_idta,products_id);

Suggestion courtesy of senior tech staff at GoDaddy who offered this feedback when I asked them if there was any reason why their server would be so slow.

28 Aug 2012, 11:06

#13

rmsimp

New Zenner

Join Date:: Feb 2011
Posts:: 14
Plugin Contributions:: 0

Re: Help with parse times?

Thank you very much, that seems to have fixed the problem. I wish the 5 weeks I was calling GoDaddy for help they would have given me that info. I wouldn't have moved the site. Again thank you

28 Aug 2012, 12:23

#14

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Help with parse times?

RMsimp:
Thank you very much, that seems to have fixed the problem.

Cool. Glad it helped!

RMsimp:
I wish the 5 weeks I was calling GoDaddy for help they would have given me that info. I wouldn't have moved the site.

Valid point. This same person has told me that they're actively working on ways to help address that in the future. They've had some big top-level mgmt changes that are re-shaping how they do things, and it's looking more promising. Hopefully this means their image can change moving forward.