Make search function run faster: using nosql or search engine?

[Imvydao]

Hello,
My site have more than 400k records and when user using search function it run very slowly. I want to improve the speed.
I have received two suggest:

1. using Nosql
2. using a search engine like elasticsearch or solr

But I haven’t more experiment in these fields. Can you please help me to choose the best solution.
Thank you.

[r937]

3. optimize your current query against your current database

[Imvydao]

This is my sql “SELECT * FROM product p LEFT JOIN user u WHERE p.uid = u.id AND p.name LIKE ‘%[search_string]%’”

Can you please give me an idea to optimize this.
Thanks.

[r937]

[quote=“Imvydao, post:3, topic:196149, full:true”]Can you please give me an idea to optimize this.
Thanks.
[/quote]
remove the name column from the product table, place it into its own MYISAM table, and create a FULLTEXT index on it

[Imvydao]

Many thanks!