Help with parse times?

[DannyVarley]

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/produ...ubergine-units

[barricades]

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

[gilby]

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"

[DannyVarley]

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.

[DrByte]

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?...s-numbers-mean
http://www.zen-cart.com/content.php?...eed-up-my-site

[DannyVarley]

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

[DannyVarley]

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!

[DrByte]

How's the performance now?

[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

[DrByte]

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?