Hello! I want to implement a powerful search engine for my ecommerce application. im using php and mysql as database. Can anyone guide me how to proceed? Is the FULL TEXT feature of MYSQL good for a large volume of data? Thanks!
+1
A:
IMHO, the MySQL Full text engine is a really poor choice.
Firstly, the number of parameters to tweak the search is almost 0.
Secondly, from my experiencem it doesn't scale.
You might consider using
Lucene is said to be the industry standard project. They have solr if you want to have a separate architecture.
They are far more advanced and perform better.
RageZ
2010-02-26 08:29:13
@Oddthinking: thanks for the edits.
RageZ
2010-02-26 08:54:30
Thank you for your help.
chupinette
2010-02-26 09:50:59
A:
This should get you started, however you will have to modify or expand on the idea.
For the second part of your question, have a look at:
Sarfraz
2010-02-26 08:29:44
A:
Recently, for an app handling a huge amount of data, we have given up both MySQL FULL TEXT and Lucene to switch on PostgreSQL which has a much more powerful native FULL TEXT engine. At least, it was what the results of our investigations said.
PierrOz
2010-02-26 08:35:32