I'm pulling my hair out, I recently upgraded my customer's cart from 1.3.7 to 1.3.8a and the cart is now running very slow. We have been running this site on Zen Cart for about three years and have never had performance problems until now. One unique thing about this cart is that we have approximately 50,000 categories.
The site is http://batterywarehouseco.com
I have looked through the forums and have not really found anything that has helped. I did however turn on display parse times. When displaying a master category that has 127 subcategories I get the following parse times.
Parse Time: 24.422 - Number of Queries: 66314 - Query Time: 16.174537784409
Why would it take 66,000 queries to display 127 subcategories? Could this be the issue?
To duplicate the issue click on "Camcorder" from the product menu. But the problem is not limited to just that category.
Displaying the same master category in admin results in no performance issue at all. Of course I have the Goto drop down box disabled. This issue that I'm have in the cart reminds me of the kind of long delays I experienced in admin with the goto box turned on. Could the cart be trying to query more than just the subcategories displayed?
Server information:
CENTOS 3.9 Linux
Apache 1.3.41
PHP 5.2.8
MySQL 4.1.22
WHM 11.24.2 / Cpanel 11.24.4
Fantastico 2.10.4 r27
Zen Cart was upgraded through Fantastico.
I am the owner of the server and have root access if needed to troubleshoot.
Any ideas, anyone? Please help.
Bookmarks