Zen Follower
- Join Date:
- Feb 2008
- Location:
- Tx gulf coast
- Posts:
- 126
- Plugin Contributions:
- 0
The CabinetGuy
thanks, I'll do that and let you know if I find something helpful and how it turns out....
Keith
Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details
This cutover relies on some testing that is still incomplete so may be cancelled at short notice
Zen Follower
thanks, I'll do that and let you know if I find something helpful and how it turns out....
Keith
Oba-san
Sounds like a winner ... :smile:
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Totally Zenned
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.
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
Zen Follower
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
Totally Zenned
I'm afraid you've run into the all-too-common scenario of having outgrown your server. Time to upgrade. :smile:
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
Zen Follower
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.
Sensei
These will help:
https://www.zen-cart.com/tutorials/index.php?article=21
https://www.zen-cart.com/tutorials/index.php?article=287
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Totally Zenned
(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?
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
Oba-san
Are you using USPS only for First Class?
What are you using Zone Rates for?
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
i added the zone rate only for Ontario, canada... for some reason, the usps would not pull the other international rates.
Keith
Oba-san
You also have 10000 products and the 1 special in the sidebox ... and going to the Specials page get 1 Special and a broken page ... how many specials do you really have?
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
Ajeh:
Are you using USPS only for First Class?
What are you using Zone Rates for?
I have turned it off again. It was not normally active.
Keith
Zen Follower
Ajeh:
You also have 10000 products and the 1 special in the sidebox ... and going to the Specials page get 1 Special and a broken page ... how many specials do you really have?
1 special
Oba-san
Just as a test, can you turn off the Specials sidebox?
What about the USPS are you only using it for First Class shipping?
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
i am now running no specials and yes, i only ship USPS 1st Class.
thx
Oba-san
If you only use USPS on 13oz orders, then you could customize it not to even get the quote for larger orders with the code in RED:
// disable only when entire cart is free shipping
if (zen_get_shipping_enabled($this->code)) {
$this->enabled = ((MODULE_SHIPPING_USPS_STATUS == 'True') ? true : false);
}
if (!IS_ADMIN_FLAG) {
global $cart;
if ($_SESSION['cart']->show_weight() > 0.8125) {
$this->enabled = false;
}
}
Then, you do not waste time on the quote and do not see that USPS at all with the error message ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Oba-san
Could you check the file:
/includes/modules/footer.php
and see if it is current and up to date?
It is missing some of the data on the Parse time display ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
Ajeh:
Could you check the file:
/includes/modules/footer.phpand see if it is current and up to date?
It is missing some of the data on the Parse time display ...
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$time_start = explode(' ', PAGE_PARSE_START_TIME);
$time_end = explode(' ', microtime());
$parse_time = number_format(($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0])), 3);
if (STORE_PAGE_PARSE_TIME == 'true') {
error_log(strftime(STORE_PARSE_DATE_TIME_FORMAT) . ' - ' . $_SERVER['REQUEST_URI'] . ' (' . $parse_time . 's)' . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
}
?>
Zen Follower
Ajeh:
If you only use USPS on 13oz orders, then you could customize it not to even get the quote for larger orders with the code in RED:
// disable only when entire cart is free shipping
if (zen_get_shipping_enabled($this->code)) {
$this->enabled = ((MODULE_SHIPPING_USPS_STATUS == 'True') ? true : false);
}
if (!IS_ADMIN_FLAG) {
global $cart;
if ($_SESSION['cart']->show_weight() > 0.8125) {
$this->enabled = false;
}
}
>
> Then, you do not waste time on the quote and do not see that USPS at all with the error message ...
Sometimes, I turn on the priority mail if I need to for a customer situation... What effect will this have on doing that?
Keith
Oba-san
Yes it would as the code is designed to turn it off if the weight is over 13oz ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Tell staff why this post should be reviewed.