php - How to speed up magento search for product over more than one lakhs products? -

I am working on a magenta site with over 100% products. Searching for a product in Search column takes more than 10 seconds.

Is there any way to increase the speed within 5 seconds?

Please help.

uses Magento EAV, so the queries are quite broad, you can tuning your work properly Reduce search time can reduce search time, messaging-fine-tuning, indexing techniques and finally you can override the search functionality and make your own customized search functionality a factor.

Ok-tuning search settings:

Navigate to system Select a Catalog »Catalog Search» One Search » Full Text , Fulltext Three The choices are believed to be the most efficient. Magento uses a separate index created in MySAM engine for full text search because InnoDB engine does not support full text index. Once you have enabled Fulltext Search, you should ensure that the "catalog search index" index is up to date. This system can be done from the "index management" and click on "reindex data". Against the search index

In addition to this, it is a good idea to clear the search queries (for example, garden furnace to garden, if furniture is a redundant term for your website, if you only get certified search rules and redirection options Using furniture and all your products are selling furniture and there is only one word that is "garden")

Mysql fine-tuning:

Just having high spectacles database server Box from Can not be used outside, you may need to zoom some settings to get the most out of the server's capabilities. Index Techniques:

You can use the Sphinx indexer, it is a very scalable search server and there are various plugins that help you integrate this into Magazine. I think it can be very useful and it can have a big effect.

Overlapping search functionality:

The best method will be to override search functionality, and to rewrite model classes and use the full text search that comes with mySQL