nodric wrote:If it helps anyone finding this, our search, and general site speed was slowing down now we had grown to +300 categories, and over 1000 products, with over 300 options.
I added most of what Simon suggested (my suggestions are below) and the site is now like lighting! Near instantaneous, and here I was bitching to my host I should have remembered to be a good DBA!
Code: Select all
ALTER TABLE `category` ADD INDEX ( `parent_id` ) ; ALTER TABLE `category` ADD INDEX ( `top` ) ; ALTER TABLE `category` ADD INDEX ( `sort_order` ) ; ALTER TABLE `category` ADD INDEX ( `status` ) ; ALTER TABLE `option` ADD INDEX ( `sort_order` ) ; ALTER TABLE `option_description` ADD INDEX ( `name` ) ; ALTER TABLE `option_value` ADD INDEX ( `option_id` ) ; ALTER TABLE `option_value_description` ADD INDEX ( `option_id` ) ; ALTER TABLE `order` ADD INDEX ( `customer_id` ) ; ALTER TABLE `product` ADD INDEX ( `model` ) ; ALTER TABLE `product` ADD INDEX ( `sku` ) ; ALTER TABLE `product` ADD INDEX ( `upc` ) ; ALTER TABLE `product` ADD INDEX ( `manufacturer_id` ) ; ALTER TABLE `product` ADD INDEX ( `sort_order` ) ; ALTER TABLE `product` ADD INDEX ( `status` ) ; ALTER TABLE `product_option` ADD INDEX ( `option_id` ) ; ALTER TABLE `product_option_value` ADD INDEX ( `product_option_id` ) ; ALTER TABLE `product_option_value` ADD INDEX ( `product_id` ) ; ALTER TABLE `product_option_value` ADD INDEX ( `option_id` ) ; ALTER TABLE `product_option_value` ADD INDEX ( `option_value_id` ) ; ALTER TABLE `product_tag` ADD INDEX ( `product_id` ) ; ALTER TABLE `product_tag` ADD INDEX ( `tag` ) ;
possible to get this to work on the version 1.4.9.3?? experience my page real slow and do not know why or what happened. Is there anyone who can look at my page and see if this module may be able to fix the problem.
www.webshop.barnbutikenvildamatilda.se
appreciate all the help I can get