[FIXED] What is the best database for full text search?

Issue

What is the best database for doing a fulltext search? Lucene and Sphinx are not an option, since the data in my case changes very frequently. Record count should be 250k+ entries, mostly product descriptions and similar. LAMP stack.

Solution

I suggest you open-source databases.

If you are serious about FTS in the long term and it is a very core feature of your product or application, I would suggest looking at Solr. If you are looking to implement simple FTS as a bolt-on to an existing PostgreSQL database, PostgreSQL FTS is a fantastic way to do this. PostgreSQL supports UTF8 and multiple languages for spelling, parsing, and stemming. MySQL only supports FTS on MyISAM tables and is really not very good for anything but the most very basic FTS implementation.

Source is here

Answered By - kamaci