Don't know what else to do ....

[webgeek8989]

I desperately need help resolving this issue. Last week we moved our OC Commerce store from a shared web server to a dedicated server with Hostgator. Since then the site has been loading the pages very slow. We went back to Hostgator today to try and resolve the problem and here is the respones that I got. Unfortunately, I don't have a clue where to go from here....Any help would be greatly appreciated.

 

 

"I've clicked around on the site while watching the MySQL database queries that go by. You have about 21 megabytes in the database that the site is linked to:

 

root@mrostop [/var/lib/mysql]# du -sh lh09mark_osc12/

21M lh09mark_osc12/

 

It would appear that because of the way the site is programmed (you are using osCommerce?) that it is recursively doing unnecessary data operations and attempting to reprocess preprocessed data as well as manipulate this data a few too many times.

 

There is also evidence of this in the memory usage. Just by clicking around on the site, as one single user, I have seen the amount of free RAM on your server drop as low as 13 MB. It would appear that there is a significant amount of inefficient programming in this site. I also checked your uptime, to see if the server had been up for a ridiculous amount of time:

 

root@mrostop [/home/lh09mark/public_html]# uptime

20:18:16 up 2 days, 6:21, 1 user, load average: 1.82, 1.10, 0.52

 

I have also preformed optimizations on the following tables:

 

+---------------------------------------------+

| Tables_in_lh09mark_osc12 |

+---------------------------------------------+

| address_book |

| address_format |

| banners |

| banners_history |

| cache |

| categories |

| categories_description |

| configuration |

| configuration_group |

| counter |

| counter_history |

| countries |

| currencies |

| customers |

| customers_basket |

| customers_basket_attributes |

| customers_info |

| geo_zones |

| languages |

| manufacturers |

| manufacturers_info |

| newsletters |

| orders |

| orders_products |

| orders_products_attributes |

| orders_products_download |

| orders_status |

| orders_status_history |

| orders_status_history_transactions |

| orders_total |

| packaging |

| pages |

| pages_description |

| products |

| products_attributes |

| products_attributes_download |

| products_description |

| products_notifications |

| products_options |

| products_options_values |

| products_options_values_to_products_options |

| products_to_categories |

| reviews |

| reviews_description |

| sessions |

| specials |

| tax_class |

| tax_rates |

| whos_online |

| zones |

| zones_to_geo_zones |

+---------------------------------------------+

 

 

This has not appeared to change this issue whatsoever.

 

Unfortunately hostgator.com can not actually offer development support. I believe that there has been a fair analysis of the issue, and thus we recommend that you contact a web developer in order to speed up the site, or find a plug-in that will improve its preformance. It is likely that the site not only inefficiently processes data, but also preforms inefficient logic routines and data processing routines in its backend.

 

Any help would be greatly appreciated!

[lpranger]

I've been having the same problem since my hosting service (hostway) upgraded their servers. I am a novice to databases and was wondering if there something I could do with my database? Clueless! :)

[Jan Zonjee]

Last week we moved our OC Commerce store from a shared web server to a dedicated server with Hostgator. Since then the site has been loading the pages very slow.

Of course which such a general question only a general reply can be given.

 

Thread on the topic: A Store Speed Optimization in Progress, Step by step from a vanilla install!

 

Output Queries Debug Contribution to see how many queries a page generates and how long it takes to execute them (find excessive amount of queries or slow ones).

 

Optimize tep_get_tax_rate() method

 

Optimize categories box

 

tep_get_category_tree optimization (only helpful on the admin side)