Thank you for the tip. I just installed the add-on and got 2 slow queries after searching in a database of more the 6000 products. These 2 slow queries comes in front when I search for an item throw a search module. The more items I got in my database the slower these queries are.
[71] => 23.855176
[72] => 41.064999
My shop is almost 100% complete and I like to solve this first when put it online. :silly:
I what file can I find these queries? :S
Code:
[71] => select count(distinct p.products_id) as total from ((j17_osc_products p left join j17_osc_products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join j17_osc_manufacturers_info m on (p.manufacturers_id = m.manufacturers_id and m.languages_id ='2'), j17_osc_products_description) left join j17_osc_specials s on p.products_id = s.products_id, j17_osc_products_description pd, j17_osc_categories c, j17_osc_products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '2' and p2c.categories_id = '28' and ((pd.products_name like '%3005%' or p.products_model like '%3005%' or p.products_model_2 like '%3005%' or m.manufacturers_name like '%3005%' or p2pef.products_extra_fields_value like '%3005%') ) and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0
Code:
[72] => select distinct p.products_image, p.ptype_id, p.products_model, m.manufacturers_name, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price from ((j17_osc_products p left join j17_osc_products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join j17_osc_manufacturers_info m on (p.manufacturers_id = m.manufacturers_id and m.languages_id ='2'), j17_osc_products_description) left join j17_osc_specials s on p.products_id = s.products_id, j17_osc_products_description pd, j17_osc_categories c, j17_osc_products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '2' and p2c.categories_id = '28' and ((pd.products_name like '%3005%' or p.products_model like '%3005%' or p.products_model_2 like '%3005%' or m.manufacturers_name like '%3005%' or p2pef.products_extra_fields_value like '%3005%') ) and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0 order by pd.products_name limit 0, 30
