Why are there 20,000 queries for a cart of 15 items?
It takes 35 seconds to show up..

I have turned off the extra windows (specials, etc
This shows up on the Checkout page- Step 1 of 3...

For the shopping cart it is 5,300 queries for these 15 items.

I am testing 1.3.8a - as our production site is on 1.3.7 and it took even longer...

I am using godaddy, shared virtual (best value for what we need)
This site has been running for 18 months, but performance seems to have gotten worse - as customers buy more products.

But even moving to my own dedicated server would not change that there are 20,000 queries for a cart of 15 items - each item has 1 attribute choice... and an image...

Does anyone know what all these queries are doing? and most important - WHY!....

I can't image that we are the only people that have shopping carts with attributes and customers that would like to buy 20+ items at a time... So, how do others deal with this?

I would like to turn most off and hope that someone else has already gone down this road to a satisfactory solution...

And can share it..

Thanks...

KevinW

Parse Time: 39.534 - Number of Queries: 20389 - Query Time: 37.0765663895

I am using godaddy
Search zencart forums for godaddy...
then consider changing hosts.
i.e.
http://www.zen-cart.com/forum/showthread.php?t=124149&highlight=treacle

Why are there 20,000 queries for a cart of 15 items?
It takes 35 seconds to show up..
Can not see what you have???
Where is your site???
How many attributes?
etc?
I am using godaddy, shared virtual (best value for what we need)
This site has been running for 18 months, but performance seems to have gotten worse - as customers buy more products.
With this type of performance, you might reconsider "best value" - Most incorrectly determine that low cost hosting is a "best value" when if one is serious about their business, this is the last place to skimp on - - Slow site equates to lost sales
But even moving to my own dedicated server would not change that there are 20,000 queries for a cart of 15 items - each item has 1 attribute choice... and an image...
Most "mass marketed" hosts push their dedicated servers when performance is at issue.

I would tend to believe that you have some type of product configuration uncommon or incorrect. As a cart with the demo products installed(maybe 200) does not exhibit querries of 20,000

This might assist

http://www.zen-cart.com/forum/showthread.php?t=125304&highlight=parse+time

I understand/see people's issues with godaddy... that would include server load times...

That doesn't explain the 20,000 queries for a cart of 15 items..
this would be slow on any server - and queries could end up being lots of disk i/o operations...

That said - I will also see about testing on another host I have access to... to compare across different hosts..

Still looking for an explanation of the queries... as that would help.. 15 items, even with 20 queries per product (prod, image, attribute, place into cart, check customer, check for other attributes, etc, etc, etc) - would amount to about 300 queries, not 20,000.

Thanks..

KevinW

kevinw:

Still looking for an explanation of the queries... as that would help.. 15 items, even with 20 queries per product (prod, image, attribute, place into cart, check customer, check for other attributes, etc, etc, etc) - would amount to about 300 queries, not 20,000.
As I stated
KoBra:

I would tend to believe that you have some type of product configuration uncommon or incorrect. As a cart with the demo products installed(maybe 200) does not exhibit querries of 20,000
You can view a Demo Products install HERE

Thanks Kobra -
I have checked my standard install too...
And the one you referenced... very good response time...
But - with a cart of 6 unique items (Matrox video with attributes)
I get
Parse Time: 3.083 - Number of Queries: 12179 - Query Time: 1.47556135876

Just showing the cart - before going to checkout - as I didn't want to register... here... same as on my test system..

EXCEPT you have excellent response times -
Who is your host - or if it is you - what is your configuration...

With your response time - that is consideration to move hosts..

On my test system I am getting
Parse Time: 2.891 - Number of Queries: 2984 - Query Time: 2.11841433817
with the same 6 items in my cart (6 Matrox video cards)
Going to checkout it is
Parse Time: 6.355 - Number of Queries: 6003 - Query Time: 4.78989988364

I expect this is the same on your site... the # queries - the time would be faster...

If you want to see the production site...
https://www.eatcakegraphics.com and you can see the product mix..

This is on 1.3.7 but I want to upgrade before we worry about changing hosts...

But - with a cart of 6 unique items (Matrox video with attributes)
I get
Parse Time: 3.083 - Number of Queries: 12179 - Query Time: 1.47556135876
12,179 for 6 items!!! Got to have something wrong???
Where can this be seen?

Let's ignore the querries and get the speed up ...

I am not seeing a valid reason for your shop to be so dog slow but it would help if you enabled the Parse Time on the bottom of your shop so that we can test some things ...

Also, could you go to the Configuration ... gZip ... and turn that on to see if you have better speed?

Thanks all - a server performance problem indeed... and I will be checking out new hosting options pronto... starting with those listed on the zen-cart site...

I will give godaddy another chance to explain why they don't have a performing solution - since I can demonstrate the problem...
And see where that takes us...

Be Well

KevinW