Forums / General Questions / My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

Locked

Started by pcwerks on 3 Jan 2008, 10:53 PM · Views: 6,632

Results 21 to 27 of 27
This thread is locked. New replies are disabled.
10 Jan 2008, 5:48 PM
#21
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

banswidthjunkie:

However, I sort of have faith that once I put the site on a dedicated Linux server that the site will speed up dramatically.I hold the same optimism. IMO Linux generally outperforms Windows esp as a webserver.

.
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.

13 Jan 2008, 12:23 PM
#22
genie avatar

genie

New Zenner

Join Date:
Jan 2008
Posts:
1
Plugin Contributions:
0

Re: My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

DrByte:

I hold the same optimism. IMO Linux generally outperforms Windows esp as a webserver.

I tend to think similarly and uh, faith's all good and all.... do you mind giving us some hard numbers about the performance after you've migrated to linux? Thanks! :)

I'll do the same after i'm done twiddling on my windows dev box and start my 2nd prototype on one of my linux VMs.

14 Jan 2008, 3:41 PM
#23
pcwerks avatar

pcwerks

New Zenner

Join Date:
Jan 2008
Posts:
19
Plugin Contributions:
0

Re: My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

Genie:

do you mind giving us some hard numbers about the performance after you've migrated to linux? Thanks! :)

I'd love to be able to give you numbers, but I'm probably not going to be migrating to linux any time soon. I have a couple dozen other websites running on this webserver (including forums, a custom web application, a web stats site, etc) that are all using PHP and MySQL and not ONE of them is slow at all. If Zen Cart is the only thing that I can find that runs slow, then I'd rather just not use it. I'd rather use osCommerce and have to add the contributions that I need than to have something that has them already built in, but is unusably slow.

Don't get me wrong, I like Zen Cart and that's why I spent over a full week trying to get it working, but I think it is horribly inefficient. On a clean install of the cart with the sample products, take one of those products that has say 8 options on it and add it to your cart 4 different ways with different options, then look at your shopping cart. It says that it uses 6192 database queries just to construct that one page. Yeah, that's over 6 THOUSAND! And every time you add the item with different options, it adds between 1500 and 2100 NEW queries. With just 4 items in the cart, it takes almost 8 seconds to parse the page. The more you buy, the slower the system gets? I don't think that any company would want to use something like that. And it's really even worse than that, because it's not really a clean install since I turned off a lot of "default on" options including half of the info-boxes and category counts.

I'm not saying Zen Cart won't work for anyone using Windows, but since all of the Apache, PHP and MySQL "tuning" I did had very little affect on it, I just don't think it will work for me. Maybe it is just my MySQL server that's slow, but it isn't slow on any of my other sites and on this hardware (3.2GHz CPU, 2GB RAM, 160GB ATA HD), it should not have a problem. Also, getting MySQL performance tuning help here (and some other places) is like pulling teeth. There seems to be a horrible mentality of "Well it took me forever to learn how to optimize SQL servers, so I'm not just going to give someone else the easy answers, they can look as long and hard as I had to." What these people don't realize is that if they would help out new people a little bit, it will be easy for those new people to learn and they would be a lot more willing to help the new people that come after them, and so on and so on. Isn't that the whole Open Source mentality?

14 Jan 2008, 5:10 PM
#24
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

We've never claimed that Zen Cart is perfect. We are well aware of the inefficiencies in the current version, and have been aggressively working on performance optimization for the next major release ... as mentioned on our roadmap (see first section on the main forum page for more info).
The inherited (and self-developed) procedural code that creates an inordinate amount of queries has been rewritten to be object-oriented and has resulted in night-and-day improvements in query efficiencies etc.
There are lots of great improvements ahead.
Unfortunately, the code differences are too great to just post a quick-fix "change this file here" for you to "fix" your site's performance problems.

You suggest that you've been snubbed by folks who know more about MySQL tuning and won't share. I'm not sure where that comment comes from. Our (including my) efforts have been around helping diagnose as well as making suggestions and suggesting ways or at least areas to tune things.

In the end, you'll do what you like, and that's entirely up to you.
May your business prosper.

.
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.

14 Jan 2008, 5:50 PM
#25
pcwerks avatar

pcwerks

New Zenner

Join Date:
Jan 2008
Posts:
19
Plugin Contributions:
0

Re: My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

DrByte:

We are well aware of the inefficiencies in the current version, There are lots of great improvements ahead.
Yeah, I have read a lot about the future improvements and I am eagerly awaiting them. I just wish I had the time to wait for them. Unfortunately, I need to find a viable ecommerce solution for now. I do plan on keeping up with the zen cart community and as soon as a more efficient version comes out, I will be trying it out!

DrByte:

You suggest that you've been snubbed by folks who know more about MySQL tuning and won't share. I'm not sure where that comment comes from.
I'm sorry, I didn't mean that to sound like the Zen Cart community was full of snobs. I didn't get snubbed as much from the people here as it might have sounded, but when I tried to get help diagnosing my bottleneck issue in this thread a long-term member told me that it wasn't a Zen Cart issue and I should check a hosting/webmaster forum. Then I read a comment in this thread where someone asked for help optimizing his my.cnf file and another long-term user wrote "...much of this is after hours of testing settings and many consider this proprietary due to their investment in testing - even though they are just settings." That was the first time I had ever heard anything like that in the development or server community. I saw a few other comments like those, but I don't remember where they were. But I saw this same thing on other sites as well, where people were claiming that MySQL optimization was a "skill" so people didn't want to just give answers to new users and suggestions of "do your own research" and "pay for classes to learn" were frequent. I thought that looking for and asking for help on forums **was **"doing your own research". But please know that my overall experience with the Zen Cart community was not a negative one, and I did receive lots of help from other users, none of which was unappreciated!

DrByte:

Our (including my) efforts have been around helping diagnose as well as making suggestions and suggesting ways or at least areas to tune things.
Again, everyone's help was VERY appreciated, especially yours DrByte. I thought I had made my thanks more clear, but looking back, I guess I didn't. I cannot tell you how much I appreciated your help in both of my threads. You gave me at least 90% of the help I received here, and it felt like I had a personal one-on-one helpdesk. You did a lot to help me diagnose where the problem might be and your courtesy is the reason why I will keep checking on the project to wait for a future version to test.

DrByte:

In the end, you'll do what you like, and that's entirely up to you. May your business prosper.
Again, I hope anyone reading my previous post did not take offense to it. I meant no hard feelings towards anyone individually or the community here itself, I just wanted to explain why I didn't think that Zen Cart was working for my current needs. I really do appreciate all of the help I did get, and will hope to be able to help someone else here in the future.

14 Jan 2008, 7:30 PM
#26
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

There's lots to look forward to, for sure!

.
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.

19 Jan 2008, 10:05 AM
#27
bexa avatar

bexa

New Zenner

Join Date:
Apr 2007
Posts:
3
Plugin Contributions:
0

Re: My ZenCart is Slow, but it's not MySQL! What is it?!? (Hosting on my own server)

I had exactly the same problem, unacceptabe parse times, 3-5 seconds with same environment, Apache running on win32 and clean, default installation with provided training products database. After weeks of :lamo: and :bangin: my head, after reading, I guess, just about any trick and hint without any result I almost gave up on Zen cart.

Then I decided not to give up on Zen, but as a final resort maybe give up on my server and try another one. I was using compilation of "all in one" server from
Xammphttp://www.apachefriends.org/en/xampp.html that looked so attractive, since it really has everything needed.

To keep it short: I completely uninstaled the xampp server and downloaded another one from http://www.wampserver.com/en/, after setup, I wasn't even touching my or php.ini, I just instaled Zen cart as before and my site's parse time is :shocking: 0.35 and something seconds. I don't want to state that apache friends xampp server is bad piece of software, but for unknown reason it simply doesn't perform (to be 100% clear on this matter, it works, but slooooowly) with Zen Cart.

So, logical conclusion from my expirience is: if you have problems with performance of Zen Cart, try different server.

And finally a big THANK YOU is in order for Zen Cart Team for a great piece of code.