So Slooooooooooooowwwwwwwwww! on GoDaddy

ZEN 1.38a

I called GoDaddy last night (I know, I know) and they told me that I needed to optimize my database for http://majortek.com. I did so and the only change was the loading of the index. The problem is on the Find Your Car link. They also told me that it was because of the number of images that I have, which I know is crap because this doesn't occur if you click on one of the other links (like one of the kit pages which is listing 298 products and images). It appears that ZEN might be loading every category below Find Your Car resulting in very slow response times. What perplexes me is that all of the categories are loaded from the beginning in the CSS flyout menu at the top.

So the questions are as follows (and thank you in advance for any help):

Is Zen loading all of the images in the subcategories when the link is activated? If so, how can I disable this?

Could it be the cache buffer size in mySQL? If so, how do I change this and what is an appropriate integer?

What other changes to the data base will Godaddy allow me to do (like allocating more memory)?

I've never restarted my DB. Should I do this and how?

Again, thank you.

I have been going through the same ishue. You can see how your site performs at this site.

http://analyze.websiteoptimization.com

towards the bottom it gives several warnings.

Bryan

GoDaddy are notorious for hosting THOUSANDS of sites on a single server. No wonder things are slow.

You may pay cheap hosting prices at GoDaddy, but the real price is MUCH higher - as you are discovering (... no customers).

Find a proper host, who understands ZC.

Is your business not worth it?

First of all, it's true, You have too many images. I have 8mbit connection with about 15 concurrent connections available in my firefox and still Your page loads like 30-40 sec. You present too much products on Your front page.

Yes, zen cart is traversing each subcategory of viewed category. If You have many entries in products_to_categories it will slow Your site sooooooooooooo much. Fortunately, I already did that kind of optimization recently and I can help You solve this issue (probably). PM me.

If You have many entries in products_to_categories moving to other hosting company will not help.

schoolboy:

GoDaddy are notorious for hosting THOUSANDS of sites on a single server. No wonder things are slow.

You may pay cheap hosting prices at GoDaddy, but the real price is MUCH higher - as you are discovering (... no customers).

Find a proper host, who understands ZC.

Is your business not worth it?

The quote by Samuel Clemens is:

"Never let school get in the way of your education"

I have already loaded Query Cache 1.5.
I have already switched to innoDB

What I need to do is stop the loading of subcategories at the second level. Not only do I have this problem on the front end, but also in admin.

Can anyone help?

Here is the response that I got from GoDaddy.

We have examined this issue and determined that when accessing this url the Zen Cart installation is making 10,000+ MySQL queries to your shared MySQL database maj**********. Most of these queries are to either the zen_categories or zen_products table, with an even split of 5000+ queries to each. This number of queries, even though each single query is processing quickly, is the reason that the pages of your Zen Cart website are taking a long time to load.

We have examined many of these queries and found that they are of one of the two below formats:

"select p.products_id from zen_products p, zen_products_to_categories p2c where p.products_id = p2c.products_id and p2c.categories_id = '2803' "

OR

"select categories_id from zen_categories where parent_id = '2803' "

It appears that when loading a page your Zen cart application will incrementally search from 1 to the maximum value in your database for both the parent_id field in table zen_categories and categories_id field in the zen_products/zen_products_to_categories tables. Most of these queries return a null set as there is no entry for that value in the table.**

Does this make any sense to anyone?

Yep. Stay tuned for Query Cache v1.6, I'll try to release it today. It should solve Your problem.

Ok, here's Query Cache v1.6:
newest version of Query Cache
You'll have to turn QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH to TRUE, it's in includes/extra_configures/query_cache.php .

Thanks again for your effrorts - much appreciated.
In looking at the file above, there is an admin folder that doesn't seem to be correct for 1.3.8a
It has the same folders as the root includes

Marg:

Thanks again for your effrorts - much appreciated.
In looking at the file above, there is an admin folder that doesn't seem to be correct for 1.3.8a
It has the same folders as the root includes

It's because one person asked me to add Query Cache to admin panel too. So I added it. Directory structure seems fine.

By the way, please post questions in support thread or on my site ;)

YUP! on GoDaddy your site will be slooow. Even if you upgrade to a premium hosting plan it will be slow.

Here's my last remaining 1.3.7 installation on GoDaddy
http://www.bulklights.com/ loads almost as slow as your site for me

amazingly enough I have a 1.3.8a site running in a subdirectory on the same server/hosting account and it's much much faster.
http://www.nativitydisplays.com/

I can only guess that it is using a much quicker MySQL server.

Now the first two My Sites: in my sig are all on BlueHost - Very Quick and the http://www.liberty-flag.com site with 5,000 SKU's is on a dedicated server VERY quick.

So long story short, the quicker you move away from GoDaddy the Sweeter your life will be.
JOhn ><>

I think I figured out a way to limit the loading of child categories. In includes/classes/categories_ul_generator.php, I changed $max_level=6, to $max_level=3. Although this truncates the loading of the 'years' level in the CSS dropdown, it seems to load a lot faster when 'Find Your Car' is clicked. For right now I am OK with the years not loading, as it was a bit cumbersome.

Give it a try and let me know if it's loading in a reasonable amount of time. Please let me know what browser you are using.

http://majortek.com

I loaded your site (main page only) in IE7 and FF ~ no joy. Still slow!

Have you turned parse time on thru admin so you can track the speed?

Tina

Hi Tina,

Yes, it's turned on but not showing. Here are the results:

Parse Time: 2.489 - Number of Queries: 57 - Query Time: 0.87882129464722

This is for the index. Here are the results for 'Find Your Car':

Parse Time: 2.187 - Number of Queries: 61 - Query Time: 0.63932590545654

It seems to be working great on my side. Could it be that everything has been cached? I tried it under FF, Missy and Safari

Parse Time: 2.489 - Number of Queries: 57 - Query Time: 0.87882129464722

This is for the index. Here are the results for 'Find Your Car':

Parse Time: 2.187 - Number of Queries: 61 - Query Time: 0.63932590545654
While you are elated in comparison to previously....This is still not good enough for a eCommerce site that carries items as yours are and many will click to a more professional -faster site for their needs

kobra:

While you are elated in comparison to previously....This is still not good enough for a eCommerce site that carries items as yours are and many will click to a more professional -faster site for their needs

No doubt my friend. Godaddy promised to call me in order to resolve my issues and yet... They are as slow responding as my website. What do you think of BlueOne.net? I know they host fark and Drew swears by them. Do you think they will be able to help me transfer my site over?

I am absolutely terrified about moving my database. Do you think they can help me tune it up?

Thanks. I guess I can use my remaining year of Godaddy as a testing server!

Don't be afraid to move the database. I've done it a dozen times without a hitch.

There is a tutorial written by DrByte on how to do this in the FAQ/Tutorial area.