Hi,

I have problem with slow search - i takes about 6 - 12 seconds...why?

For exemple, when I search "GSM zasuvka":

http://www.puhy.cz/search/results.ht...rd=gsm+zasuvka

it loads very slow (you can try it).

It generates this SQL query:

SELECT DISTINCT p.products_model, p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id FROM (zs_products p
LEFT JOIN zs_manufacturers m
USING(manufacturers_id), zs_products_description pd, zs_categories c, zs_products_to_categories p2c )
LEFT JOIN zs_meta_tags_products_description mtpd
ON mtpd.products_id= p2c.products_id
AND mtpd.language_id = 1 WHERE (p.products_status = 1
AND p.products_id = pd.products_id
AND pd.language_id = 1
AND p.products_id = p2c.products_id
AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%gsm%'
OR p.products_model
LIKE '%gsm%'
) and (pd.products_name LIKE '%zásuvka%'
OR p.products_model
LIKE '%zásuvka%'
) )) order by p.products_sort_order, pd.products_name

When I paste this query to SQL, it is executed on 1,5 sec....


Why searching on web is very slow? Search in description is off and atributes too...

There is about 70000 products.

Many thanks for some idea.