So Slooooooooooooowwwwwwwwww! on GoDaddy

[majoritywhip]

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.

[Beaches]

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

[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?

[data_digger]

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.

[majoritywhip]

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"

[majoritywhip]

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?

[majoritywhip]

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?

[data_digger]

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

[data_digger]

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 .

[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