The CabinetGuy

[CabinetGuy]

thanks, I'll do that and let you know if I find something helpful and how it turns out....

Keith

[Ajeh]

Sounds like a winner ...

[BlindSide]

Hey Keith. As Zen Cart's resident "server tech guy," Linda asked me to step in and offer some advice.

Based on Linda's encyclopedic knowledge of product attributes, we believe that the server is choking on the sheer volume of data in this scenario. The available memory is not enough to hold the data. So there's two memory limits that you need to check, and max out.

Linda pointed you to the first one, PHP's memory limit (memory_limit in php.ini). You upped it to 512 MB, but I would guess that your server has additional capacity. Find out how much RAM your system has, and then set memory_limit somewhere below that amount. For example, if your system has 4 GB of memory, I might set PHP's memory_limit to 3 GB.

memory_limit = 3G

Restart Apache, and try your checkout again.

If you still choke out, then the choke point is likely further down the stack in MySQL. One step at a time though; try this and report back.

[CabinetGuy]

thanks for the insight.

my vps plan has a limit of 768 mb of php memory and we are maxed out without having to go to another plan.

With this, there is no improvement.

thx

[BlindSide]

I'm afraid you've run into the all-too-common scenario of having outgrown your server. Time to upgrade.

[CabinetGuy]

so, you think this is solely a function of my server?

I can process large orders in my cart all day long until I sign in...that's when the trouble starts. If I sign in, the system seems to time out. If i do this as a guest, everything is fine until I sign in then it bogs...

What is the relationship with signing in versus not signing in...?

Keith.

[DrByte]

These will help:
https://www.zen-cart.com/tutorials/index.php?article=21
https://www.zen-cart.com/tutorials/i...hp?article=287

[BlindSide]

(Per discussion with Ajeh) When you're not logged in, items in the shopping cart exist only in the session. As soon as you log in, those items get permanently stored in the database. In this case, your products' high degree of complexity is exposing some inefficiencies in the optimization of the core code in ZC v1.x, resulting in the slowdown you see, due to higher number of queries.

Unfortunately, optimizing memory in MySQL is not as straightforward as with PHP. To get started, could you please post the contents of your my.cnf file?

[Ajeh]

Are you using USPS only for First Class?

What are you using Zone Rates for?

[CabinetGuy]

i added the zone rate only for Ontario, canada... for some reason, the usps would not pull the other international rates.

Keith