Too many items in cart? Or is it too many attributes?

[CabinetGuy]

I have a problem with shopping cart when shopper puts too many items that have multiple attributes. I am running 1.39h and I have products with as many as 10 different attributes per product.

Right now, when customer or myself, for that matter, enters the eighth item, the cart first goes out of alignment to the template and then if you select checkout, the page just goes blank and that's it, no checkout.

I have attached a couple of screen captures to demonstrate.

I have this issue with all of this type of product and I cannot afford to limit my cart contents....can someone help?

If any other information is needed, let me know.

Keith

[Ajeh]

If you look in your Zen Cart Admin at the Tools ... Server Info ... what are you showing from the:
Server Information
< stuff here>
PHP Version X.X.X

[CabinetGuy]

Server Host: gator1073.hostgator.com (174.120.168.2) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.38.7 Database: MySQL 5.1.52
Server Date: 08/21/2011 11:18:59 Database Date: 08/21/2011 11:18:59
Server Up Time: 11:18:59 up 56 days, 13:13, 0 users, load average: 12.98, 11.18, 9.86 HTTP Server: Apache mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Database Data Size: 29,990 kB Database Index Size: 5,670 kB

[Ajeh]

The load on the server is high ...

You might talk to your hosting provider about moving your site to a less loaded server ...

[CabinetGuy]

so, you think this is load related?

[Ajeh]

Partially ...

There can be other factors but the first is the load on the server ...

Can you turn on your parse times?

[CabinetGuy]

Parse Time: - Number of Queries: 3009 - Query Time: 0.38964174850464

if i try and click on edit cart, the page won't even totally load, just as shown in the screen caps on the link...

[Ajeh]

Go to the Configuration ... Layout Settings ... and turn off the Shopping Cart Totals just to see the affect of not doing the extra calculations ...

Shopping Cart - Show Totals
Show Totals Above Shopping Cart?
0= off
1= on: Items Weight Amount
2= on: Items Weight Amount, but no weight when 0
3= on: Items Amount

[CabinetGuy]

Parse Time: - Number of Queries: 3465 - Query Time: 0.72650301528931
Parse Time: - Number of Queries: 3148 - Query Time: 0.53565443077088
Parse Time: - Number of Queries: 1735 - Query Time: 0.20878478173828

The third time is if I close my loaded cart and open a new one with a single item.

I cannot get the parse time from the other (full) cart because it prevents me from getting to the footer of the page when it freezes up.

[CabinetGuy]

if i remove one item with a bunch of these attributes, I get a workable shopping cart again with these times:
Parse Time: - Number of Queries: 52059 - Query Time: 7.0231287233277
Parse Time: - Number of Queries: 53647 - Query Time: 7.1890023490295
Parse Time: - Number of Queries: 51087 - Query Time: 6.5328909668731

Three different times with the cart with the one less item... the final time is when i click on "checkout"