Slow osC catalog

[nromain]

Hi,

 

My site http://northamericantuning.com/catalog/ is running painfully slow for a few days.

 

Nothing has changed as far as code for a few weeks.

 

The hosting firm tells me their servers are working fine.

 

Any ideas folks?

 

Appreciate it.

[Jan Zonjee]

My site northamericantuning.com/catalog/ is running painfully slow for a few days.

 

Nothing has changed as far as code for a few weeks.

 

The hosting firm tells me their servers are working fine.

It still is slow to load. One thing that is certainly wrong is the location of the flash movie on the index page (note the missing .com):

http://northamericantuning/flash/featured_products_mustang_challenger_camaro.swf

You could try the 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).

 

Did you add the indexes to tables form RC2a: to improve performance (especially the one on specials is helping dramatically).

alter table banners add index idx_banners_group (banners_group);
alter table banners_history add index idx_banners_history_banners_id (banners_id);
alter table currencies add index idx_currencies_code (code);
alter table customers add index idx_customers_email_address (customers_email_address);
alter table customers_basket add index idx_customers_basket_customers_id (customers_id);
alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id);
alter table orders add index idx_orders_customers_id (customers_id);
alter table orders_products add index idx_orders_products_orders_id (orders_id);
alter table orders_products add index idx_orders_products_products_id (products_id);
alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id);
alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id);
alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id);
alter table products add index idx_products_model (products_model);
alter table products_attributes add index idx_products_attributes_products_id (products_id);
alter table reviews add index idx_reviews_products_id (products_id);
alter table reviews add index idx_reviews_customers_id (customers_id);
alter table specials add index idx_specials_products_id (products_id);
alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id);