Slow product search in the storefront

If products in your store have a lot of tags assigned, simple product search in the storefront might be carried out significantly longer than the average page load time. To speed up the search process, run the following SQL query which will add auxiliary indexes to the database:

ALTER TABLE `SC_tagged_objects` ADD INDEX ( `object_id` , `tag_id` );

Attention: Before applying direct changes to the database do back up its contents, it will help you to restore it to the original condition in case of a failure!